请教一下类似于SqLserver中的select top 1 from table order by id 在ORacle中是怎么写的。 SQLSERVER取前10条记录怎样取
oracle sql\u67e5\u8be2\u524d50\u4e2a\u8bb0\u5f55 \u6211\u7684\u8bed\u53e5\u662fselect top 50 * from table order by id desc;oracle\u6ca1\u6709top\u7684\u8bed\u6cd5\uff0c\u9650\u5236\u8bb0\u5f55\u6570\u90fd\u662f\u4f7f\u7528rownum < N\u6216\u8005rownum <= N\u7684\u3002
\u4f60\u8fd9\u7528\u5f97\u7740\u5d4c\u5957\u5417\u3002\u4e0d\u662f\u591a\u6b64\u4e00\u4e3e\u5417\uff1f
select top 10 A.name,B.sex from userinfo A,sexinfo B where A.id = B.id and A.sex = B.sexid order by A.id
\u8981\u662f\u771f\u8c61\u4f60\u90a3\u4e48\u5199\u7684\u8bdd\uff0c\u4e5f\u53ef\u4ee5
select top 10 C.name,C.sex from (select A.name name,B.sex sex ,A.id id from userinfo A,sexinfo B where A.id = B.id and A.sex = B.sexid) C order by A.id
简单地说,实现方法如下所示:
SELECT 列名1...列名n FROM
(SELECT 列名1...列名n
FROM 表名 ORDER BY 列名1...列名n)
WHERE ROWNUM <= N(抽出记录数)
ORDER BY ROWNUM ASC
下面举个例子简单说明一下。
顾客表customer(id,name)有如下数据:
ID NAME
01 first
02 Second
03 third
04 forth
05 fifth
06 sixth
07 seventh
08 eighth
09 ninth
10 tenth
11 last
则按NAME的字母顺抽出前三个顾客的SQL语句如下所示:
SELECT * FROM
(SELECT * FROM CUSTOMER ORDER BY NAME)
WHERE ROWNUM <= 3
ORDER BY ROWNUM ASC
输出结果为:
ID NAME
08 eighth
05 fifth
01 first
绛旓細TCP 65=TACACS-Database ServiceTCP 66=Oracle SQL*NET,AL-BarekiTCP 67=Bootstrap Protocol ServerTCP 68=Bootstrap Protocol ClientTCP 69=W32.Evala.Worm,BackGate Kit,Nimda,Pasana,Storm,Storm worm,Theef,Worm.Cycle.aTCP 70=Gopher鏈嶅姟,ADM wormTCP 79=鐢ㄦ埛鏌ヨ(Finger),Firehotcker,ADM wormTCP 80=...
绛旓細鏁版嵁搴撹繛鎺ワ細宸ョ▼---寮曠敤--microsoft activex data objects X.X library;ADO鎺т欢锛氬伐绋---閮ㄤ欢--microsoft windows controls X.X
绛旓細鐥呮瘨璋冨姩浜嗕竴浜涘唴鏍稿嚱鏁伴殣钘忎簡杩欎袱涓湇鍔,涓嬩釜鐙欏墤www.zhulinfeng.com鍏ㄩ潰妫鏌,鐗瑰埆鏄疭SDT_hook,鐢ㄦ暟瀛楃鍚嶉獙璇!娌℃湁琚獙璇佺殑鏄棶鍙风殑,浣犵敤鍙抽敭鍗曞嚮灏辨湁鏁板瓧绛惧悕楠岃瘉,鍑℃槸绾㈣壊鎵揦鐨勯兘鍙互瑙嗕綔鍨冨溇澶勭悊,闄ら潪鏄綘璁よ瘑鐨勪笢瑗!瀹冩湁璺緞鏄剧ず鐨!鏁板瓧绛惧悕鍙兘楠岃瘉鍐呮牳,杩涚▼,妯″潡,鍚姩椤!
绛旓細濡傦細*.drv涓鸿澶囬┍鍔ㄧ▼搴(Driver)銆*.fon鍜*.fot閮芥槸瀛楀簱鏂囦欢銆*.grp涓哄垎缁勬枃浠(Group)銆*.ini涓哄垵濮嬪寲淇℃伅鏂囦欢 (Initiation)銆*.pif涓篋OS鐜涓嬬殑鍙墽琛屾枃浠跺湪Windows涓嬫墽琛屾椂鎵闇瑕佺殑鏂囦欢鏍煎紡銆*.crd鍗冲崱鐗囨枃浠(Card)銆*.rec鍗宠褰曞櫒瀹忔枃浠(Record)銆*.wri鍗虫枃鏈枃浠(Write)锛...
绛旓細.image:MAcintosh纾佺洏鏄犺薄鏂囦欢,甯歌浜庤悕鏋滄満鐨凢TP缃戠偣,鍦∕acintosh涓敱Shrink Wrap澶勭悊 .ime:Windows涓嬬殑杈撳叆娉曟枃浠 .img:纾佺洏鏄犺薄鏂囦欢,鐢℉D-COPY,WinImage绛夊伐鍏锋墦寮鍚庡彲浠ユ仮澶嶅埌涓寮犵鐩樹笂 .inc:姹囩紪璇█鍖呭惈鏂囦欢,绫讳技C/C++涓殑.H鏂囦欢 .inf:Windows涓嬬殑杞欢瀹夎淇℃伅,Windows鐨勬爣鍑嗗畨瑁呯▼搴忔牴鎹鏂囦欢鍐呯殑瀹夎淇℃伅...
绛旓細.image:MAcintosh纾佺洏鏄犺薄鏂囦欢,甯歌浜庤悕鏋滄満鐨凢TP缃戠偣,鍦∕acintosh涓敱Shrink Wrap澶勭悊 .ime:Windows涓嬬殑杈撳叆娉曟枃浠 .img:纾佺洏鏄犺薄鏂囦欢,鐢℉D-COPY,WinImage绛夊伐鍏锋墦寮鍚庡彲浠ユ仮澶嶅埌涓寮犵鐩樹笂 .inc:姹囩紪璇█鍖呭惈鏂囦欢,绫讳技C/C++涓殑.H鏂囦欢 .inf:Windows涓嬬殑杞欢瀹夎淇℃伅,Windows鐨勬爣鍑嗗畨瑁呯▼搴忔牴鎹鏂囦欢鍐呯殑瀹夎淇℃伅...