A. 求一條篩選數據的sql語句
select
姓名,
(case
when
類別='工資'
then
金額
else
0
end
)
as
工資,
(case
when
類別='工資'
then
0
else
金額end
)
as
獎金
from
表
group
by
姓名
B. Sql篩選語句
declare @tiaojian varchar(1000)
declare @str varchar(1000)
set @tiaojian=' where 1=1 '
if 品牌條件不為空
set @tiaojian = @tiaojian+'and 品牌欄位 ='+@品牌
if 品類條件不為空
set @tiaojian = @tiaojian+'and 品類欄位 ='+@品類
if 解析度條件不為空
set @tiaojian = @tiaojian+'and 品牌欄位 ='+@解析度
case
when @價格 ='價格具體值' then ' and 價格欄位 between 具體值 and 具體值 '
when @價格 ='價格具體值' then ' and 價格欄位 between 具體值 and 具體值 '
else set @tiaojian = @tiaojian +''
@str='select * from 表 + 'tiaojian
exec @str
C. Sql 對數據進行篩選 請問怎麼寫語句
--DROPTABLEtest
CREATETABLEtest(aINT,bINT,cVARCHAR(10))
INSERTINTOdbo.test
(a,b,c)
SELECT5038,1,'ss030001'
UNIONALL
SELECT
5038,1,'ss030001'
UNIONALL
SELECT
5038,2,''
UNIONALL
SELECT
5038,3,''
UNIONALL
SELECT
5038,2,'444'
UNIONALL
SELECT
5121,1,''
UNIONALL
SELECT
5038,3,'123456'
SELECT*FROMtestWHEREisnull(c,'')<>''
UNIONall
SELECTa,b,c
FROM
(
SELECTROW_NUMBER()OVER(PARTITIONBYaORDERBYa)id,*
FROMtest)t1
WHEREid=1ANDaNOTIN(SELECTaFROMtestWHEREisnull(c,'')<>'')
結果：
5038 1 ss030001
5038 1 ss030001
5038 2 444
5038 3 123456
5121 1
D. 關於篩選的SQL語句
select max(click) as haha from new_datas
haha是自設欄位 你可以隨便改名字
E. sql篩選語句
疑問：既然你想分組統計N條記錄，你的SQL語句統計原則是什麼？
以下是分組取前N條數據記錄
createtablet_gulp(gidint,userIdvarchar(20),scoreint);
go
insertintot_gulpvalues(1,'A',50);
insertintot_gulpvalues(1,'B',40);
insertintot_gulpvalues(1,'C',60);
insertintot_gulpvalues(2,'D',70);
insertintot_gulpvalues(2,'E',80);
insertintot_gulpvalues(2,'F',90);
go
selectgid,userId,score
fromt_gulpast
wheret.userIdin
(
selecttop2userId
fromt_gulp
wheregid=t.gid
orderbyscoredesc
)
orderbygid,scoredesc
F. 用SQL語句實現數據篩選
--將欄位條件篩選建立臨時表
selecttop100*
into#temp
fromtable
wherenamenotin("%批發%","不含'%廠")
andregionin("餐飲",..."副食")--填寫完每個經營面
--返回數據表,企業數和個體戶,這個區分不知道用什麼,所以第二個欄位還需要改
selectprovince,count(distinctname)asnum_company,
casewhenname="個體戶"thencount(distinctname)asnum_indivial
from#temp
G. sql語句篩選
select*from(
select*,row_number()over()seqfrom[表A]
)twhereseq=1
H. 在SQL資料庫中，按照英文首字母對資料庫中的漢字進行篩選
Create Function RmGetPY(@chn nchar(1))
returns char(1)
as
begin
declare @n int
declare @c char(1)
set @n = 63
select @n = @n +1,@c = case chn when @chn then char(@n) else @c end from(
select top 27 * from (
select chn =
'吖' union all select
'八' union all select
'嚓' union all select
'咑' union all select
'妸' union all select
'發' union all select
'旮' union all select
'鉿' union all select
'丌' union all select
'丌' union all select
'咔' union all select
'垃' union all select
'嘸' union all select
'拏' union all select
'噢' union all select
'妑' union all select
'七' union all select
'呥' union all select
'仨' union all select
'他' union all select
'屲' union all select
'屲' union all select
'屲' union all select
'夕' union all select
'丫' union all select
'帀' union all select @chn) as a
order by chn COLLATE Chinese_PRC_CI_AS
) as b
return(@c)
end
go
Create Function GetAllPY(@chn nvarchar(100))
returns varchar(30)
as
begin
declare @i int,@j int,@result varchar(100)
set @result=''
set @i=len(@chn)
set @j=1
while @j<=@i
begin
set @result = @result + dbo.RmGetPY(substring(@chn,@j,1))
set @j=@j+1
end
--將助記碼限定在30個字母之內
select @result=(case when len(@result)>30 then left(@result,30) else @result end)
return @result
end
先加這兩個函數，然後
select * from table where dbo.GetAllPY(欄位) like 'J%'
I. 用sql語句進行篩選
select姓名from表where課程!='A'
J. SQL篩選語句
select count(0) from xs where 戀愛='F'
用的count（0）的原因是你只要記錄數。沒有必要用*將所有欄位都差一次這樣可以減輕資料庫的負擔。使得查詢所用的時間更短。在數據少的情況下看不出來。但是一旦數據多了，就很明顯了。比如：幾萬條數據，幾十萬條數據。