SQL语句的问题，关于SELECT 一个关于SQL中select语句的问题
\u5173\u4e8eSQL\u8bed\u53e5\u7684\u95ee\u9898\uff0cselect\u8bed\u53e5\u3002\u8fd9\u6837\u5c31\u7ed9\u4e2a\u8868\u5f88\u96be\uff0c\u4f60\u77e5\u9053\u90a3\u4e2a\u8868\u8ddf\u90a3\u4e2a\u8868\u5173\u8054\uff0c\u7136\u540e\u7528\u5173\u8054\u67e5\u8be2\u5c31OK\u4e86
Select min(\u4e00\u4e2a\u5b57\u6bb5) from \u8868
min(\u4e00\u4e2a\u5b57\u6bb5) \u53d6\u6700\u5c0f\u503c
\u5982\u679c\u4f60\u60f3\u53d6\u6700\u5927\u503c\u5c31\u7528 max(\u4e00\u4e2a\u5b57\u6bb5),\u8fd8\u53ef\u4ee5\u53d6\u548c\u503c sum(\u4e00\u4e2a\u5b57\u6bb5)
\u5982\u679c\u4f60\u7528\u7684\u662fsql server\u6570\u636e\u5e93\uff0c\u4e0b\u9762\u8fd9\u4e2a\u65b9\u6cd5\u4e5f\u53ef\u4ee5\uff1a
Select TOP 1 \u4e00\u4e2a\u5b57\u6bb5 from \u8868 order by \u4e00\u4e2a\u5b57\u6bb5 asc
to kutengshu:
Select TOP 1 \u4e00\u4e2a\u5b57\u6bb5 from \u8868 where (\u4f60\u7684\u6761\u4ef6) order by \u4e00\u4e2a\u5b57\u6bb5 asc
text
——————
about
out
where
this
come
isit
comeisit
isitko
kois
示例代码如下：
declare @a varchar(20),@b varchar(20),@c varchar(20) /*三个搜索条件*/
set @a = 'is'
set @b = 'it'
set @c = 'ko'
select *,IDENTITY(int,1,1) as id into #Temp from
(
select *,1 as lv from test where text like '%'+@a+'%' and text like '%'+@b+'%' and text like '%'+@c+'%'
union select *,2 as lv from test where (text like '%'+@a+'%' and text like '%'+@b+'%') or (text like '%'+@a+'%' and text like '%'+@c+'%') or (text like '%'+@b+'%' and text like '%'+@c+'%')
union select *,3 as lv from test where text like '%'+@a+'%' or text like '%'+@b+'%'or text like '%'+@c+'%'
) as tmp order by lv
select text from #Temp t1 where
id=(select min(id) from #Temp t2 where t1.text = t2.text) order by id
drop table #Temp
列出结果如下：
text
----------
isitko
comeisit
isit
kois
this
这样就满足了你的需求：满足更多条件的排序更靠上。
用包含就行了select * from 表 where xxx='%x%' and xxx='%y%'.....
绛旓細1銆sele * from a.dbf where 濮撳悕=鈥滃紶涓夆2銆乻ele * from a.dbf where 鎬у埆=.t.3銆乻ele 閮ㄩ棬锛宻um(宸ヨ祫) as 宸ヨ祫鎬婚 from a.dbf group by 閮ㄩ棬 4銆佷笉浼
绛旓細sele 瀛楁鍚 from 琛ㄥ悕 into array 鏁扮粍鍚 &&鍔犱笂into array灏卞彲浠ュ皢缁撴灉瀛樺埌鏁扮粍涓簡銆
绛旓細娌℃壘鍒皊alepeople锛屾牴鎹崟璇嶆剰鎬濇垜灏卞綋鎴怱alesperson澶勭悊浜嗐傚弬鑰冨涓嬶紝浣欓棶鍐嶅锛氣憼sele SalespersonName,sum(Amount) from 琛╫rder ;group by SalespersonName havin sum(Amount)>=500 浣犵殑琛ㄥ悇涓瓧娈靛お娣蜂贡浜嗭紝浣犳暣鐞嗕竴涓嬶紝杩樻湁璇存竻妤歴alepeople鏄粈涔堬紝缁欐垜鍙戞秷鎭紝鎴戝啀鍥炵瓟鍚с
绛旓細select 瀛︾敓鍚嶅瓧娈 from 琛ㄥ悕 where 绉戠洰瀛楁1>80 and 绉戠洰瀛楁2>80鈥;妤间富浣犲鐓х潃涓婇潰鐨勬妸鐩稿簲鐨勪笢瑗挎斁杩涘幓灏辫兘鏌ユ壘浜嗭紝where 鍚庨潰鐨勬潯浠朵綘鐪嬩綘鑷繁鐨勭鐩湁澶氬皯灏卞啓澶氬皯锛屾寜鐓ч偅鏍煎紡灏辫銆
绛旓細sele 濮撳悕 from 瀛︾敓 where 瀛﹀彿 in;(sele 瀛﹀彿 from 閫夎 where 鎴愮哗>=70;group by 瀛﹀彿;having count (*)>=3);order by 1;into dbf results
绛旓細褰撲娇鐢sql璇彞鏃讹紝鍩烘湰缁撴瀯灏辨槸锛歴ele鈥斺攆rom鈥斺攚here锛宻ele 鍚庨潰鏄煡鎵剧殑鍐呭锛宖rom鍚庨潰鏄〃鍚嶏紝where鍚庨潰鏄弧瓒崇殑鏉′欢銆俵ocate for鏄湪宸ヤ綔绐楀彛涓樉绀烘弧瓒砯or鍚庨潰鐨勬潯浠剁殑绗竴鏉¤褰曘俿ele 鏌ヨ婊¤冻鏉′欢鐨勮褰曪紝鍙互澶氳〃鏌ヨ锛屾煡璇㈢殑鏃跺欒〃鍙互涓嶇敤鎵撳紑銆俿eek浠庡綋鍓嶆墦寮鐨勮〃涓壘鍒板搴旂殑绗竴鏉¤褰曘
绛旓細浣犵殑table1鍜宼able2鐨勫鍚嶅緢鏄庢樉瑕佷繚璇佹槸鍞竴鐨 select t1.濮撳悕,t1.鍏ュ巶鏃ユ湡,t1.琛ㄧ幇,t2.鍙傚姞宸ヤ綔鏃ユ湡,t2.宸ヤ綔鍦扮偣 from table1 t1,table2 t2 where t1.濮撳悕=t2.濮撳悕 浣犳妸鏌ヨ缁撴灉鐪嬪仛涓涓〃锛岀劧鍚庢兂鎯宠鎬庝箞鏌ワ紝搴旇鏈夋濊矾浜嗗惂锛
绛旓細sql璇彞涓殑group by鐨勭敤娉,姹傚ぇ绁炴寚鐐广 鎴戞潵绛 8涓洖绛 #鐑# 涓轰粈涔堢幇鍦ㄦ儏鏅枩鍓ц秺鏉ヨ秺灏...涓轰簡閬垮厤鍑虹幇姝闂,璇峰皢 dbo.cube 鏇挎崲涓篬dbo].[cube] 鎴栧皢 dbo.rollup 鏇挎崲涓篬dbo].[rollup]...SELE 瀛﹀彿,AVG(鎴愮哗) FROM 閫夎 GROUP BY 瀛﹀彿璇存槑:鍦ㄦ鏌ヨ涓,閫夋寜瀛﹀彿灞炴ц繘琛屽垎缁,鐒跺悗鍐嶈绠...
绛旓細鏄 selcet *from 琛 where datediff(dd,鏃ユ湡1锛屾棩鏈2)>1
绛旓細鏈夊姙娉曠殑,浣跨敤宓屽鏂瑰紡灏卞彲浠,涓嶇鍏抽敭瀛楁槸1000杩樻槸1 涓囬兘娌″叧绯,鍋氭硶涓鑸槸杩欐牱鐨.select * from shuzi.dbf where _涓诲壇绔="涓荤" and 璇︾粏鍦板潃 IN (SELECT 璇︾粏鍦板潃 FROM 瀛樻斁鍏抽敭瀛楃殑琛)杩欓噷瀛樻斁鍏抽敭瀛楃殑琛ㄦ槸浣犱汉宸ョ敓鎴愯繕鏄氳繃鏉′欢绛涢夐兘鍙互,浣嗘槸閮芥槸宸插瓨鍦ㄧ殑琛,涓鑸笉浼氭槸涓存椂涓涓竴涓墜宸...
