sql语句中select查询时什么时候加'*'号
逗号?逗号是用于分割字段和表等信息的,逗号分割的是并列的关系
比如要查询几个字段
select
字段1,字段2,字段3……这里用逗号
比如要从几个表里查
……from
表1,表2……
比如一个条件要满足某个范围
where
id
in
(1,2,3,4,5.......)
比如要按几个条件排序
order
by
id
desc,hits
desc...
比如要按几个条件分组
group
by
id,name.....
绛旓細select 瀛﹀彿,濮撳悕,鎬у埆 from 瀛︾敓 where WHRER 鍏氬憳=1锛坆ool 绫诲瀷 true 涓1 false 涓0锛
绛旓細瀵逛簬 Oracle 鏉ヨ锛 From 鏄繀椤鐨銆傚氨绠椾綘鍙 select 1 浣犱篃瑕佸姞涓 FROM dual 瀵逛簬 SQL Server 浠ュ強 MySql 锛 涓涓 SQL 璇彞锛 鏄彲浠ユ病鏈 FROM 鐨勩備緥濡傦細1> select 1 as [A], 2 as [B]2> go A B --- --- 1 2 (1 琛屽彈褰卞搷)浣嗘槸浠庤繖涓 鍑洪浜虹殑蹇冪悊...
绛旓細SQL璇彞涓锛屽湪鏌ヨ鐨剆elect鍚庣洿鎺ュ啓null鍗冲彲瀹屾垚鏌ヨ鍑轰竴涓櫄鍒楋紝骞剁敤null濉厖銆傚伐鍏凤細SqlServer 2008 R2 姝ラ锛1銆乼est琛ㄤ腑鏈夊涓嬫暟鎹細2銆佽鏌ヨ鏁翠釜琛紝骞舵坊鍔犱竴涓櫄鍒楋紝鍒楀悕涓篏ender锛屽~鍏呭间负null锛屽彲鐢ㄥ涓嬭鍙ワ細select *,null Gender from test3銆佹煡璇㈢粨鏋滀腑鍙锛岃櫄鍒楀凡鏋勫缓瀹屾瘯锛屽苟涓斾互null鍊...
绛旓細d from (select a,b,c,d,row_number() over(order by b) rn from test) t1,(select min(rn) min_rn from (select a,b,c,d,row_number() over(order by b) rn from test) t group by b) t2 where t1.rn=t2.min_rn ;璨屼技绠鍗曪紝鍏跺疄铔湁鎰忔鐨涓涓棶棰橈紝鏈熷緟鏇村ソ鐨勭瓟妗堛
绛旓細2銆佷箣鍚庡湪璇ョ晫闈腑锛岀偣鍑诲乏涓婅鈥滄柊寤鏌ヨ鈥濋夐」銆3銆佹帴鐫鍦ㄨ鐣岄潰涓紝杈撳叆鏌ヨ1996骞村嚭鐢熺殑瀛︾敓鐨勫鍙,濮撳悕鍜屽嚭鐢熸棩鏈鐨剆ql璇彞鈥select no,name,birthday from test1 where DATEPART(yyyy, birthday)='1996'鈥濄4銆佺劧鍚庡湪璇ョ晫闈腑锛岀偣鍑诲乏涓婃柟鈥滄墽琛屸濇寜閽5銆佹渶鍚庡湪璇ョ晫闈腑锛屾樉绀烘煡璇1996骞村嚭鐢...
绛旓細3銆佸湪琛2涓彃鍏ユ暟鎹 insert into test_case2 values(1,'aa');insert into test_case2 values(2,'bb');insert into test_case2 values(3,'cc');insert into test_case2 values(6,'ee');commit;4銆佷袱琛ㄥ叧鑱旓紝骞剁紪鍐檆ase when鐨勮鍙 select t.*,case when b.id is not null then '...
绛旓細鍙互 SQL涓璖ELECT宓屽SELECT璇彞鏄緢甯歌鐨凷QL璇彞锛屽祵濂桽ELECT璇彞涔熷彨瀛愭煡璇紝涓涓猄ELECT 璇彞鐨勬煡璇缁撴灉鑳藉浣滀负鍙︿竴涓鍙ョ殑杈撳叆鍊笺傚瓙鏌ヨ涓嶄絾鑳藉鍑虹幇鍦╓here瀛愬彞涓紝涔熻兘澶熷嚭鐜板湪from瀛愬彞涓紝浣滀负涓涓复鏃惰〃浣跨敤锛屼篃鑳藉鍑虹幇鍦╯elect list涓紝浣滀负涓涓瓧娈靛兼潵杩斿洖銆備緥1锛歴elect瀛愭煡璇㈠嚭鐜板湪Where瀛愬彞...
绛旓細from Table1 鏄剧ず鎵鏈夊垪鐨勮褰曘select a,b,c from table1 灏卞彧鏄剧ず a,b,c 涓夊垪鐨勮褰曘傗 * 鈥濓紝鎶婅〃涓殑鎵鏈夎褰曢兘鏄剧ず鍑烘潵锛岃繖鍦ㄥ疄闄呭紑鍙戜腑灏介噺閬垮厤锛屾晥鐜囧緢浣庯紝鍒版椂鍊欑淮鎶や篃姣旇緝鍥伴毦銆傝嚦浜庝綘璇村湪浠涔堟儏鍐典笅浣跨敤锛屼竴鑸兘鏄嚜宸辨兂棰勮琛ㄨ褰曪紝鎴栬〃缁撴瀯鐨勬椂鍊鍙互 SELECT * FROM TABLE ...
绛旓細SQL涓煡璇A琛ㄤ腑鐨勬暟鎹湁閮ㄥ垎瀛樺湪B琛ㄤ腑骞舵樉绀哄嚭鏉ワ紝鍙互鍙傝冧笅闈㈠嚑绉嶆柟娉曪細1銆select * from B琛 where item_no in (select 鏉$爜 from A琛)2銆乻elect * from A琛,B琛 where A琛.鏉$爜=B琛.item_no
绛旓細select * from 琛ㄥ悕 where Convert(varchar(200),fcsj, 111) = '2009/12/12'