锘??xml version="1.0" encoding="utf-8" standalone="yes"?>在线看视频你懂的,成人欧美一区,91在线观看免费高清http://www.aygfsteel.com/iamnick/zh-cnWed, 18 Jun 2025 18:47:27 GMTWed, 18 Jun 2025 18:47:27 GMT60oracle 涓殑 rownum http://www.aygfsteel.com/iamnick/archive/2007/07/23/131819.htmliamnickiamnickMon, 23 Jul 2007 02:32:00 GMThttp://www.aygfsteel.com/iamnick/archive/2007/07/23/131819.htmlhttp://www.aygfsteel.com/iamnick/comments/131819.htmlhttp://www.aygfsteel.com/iamnick/archive/2007/07/23/131819.html#Feedback0http://www.aygfsteel.com/iamnick/comments/commentRss/131819.htmlhttp://www.aygfsteel.com/iamnick/services/trackbacks/131819.html 1 鍙互鏌ヨ鍑鴻褰曪紝rownum 鏄竴涓吉鍒椾粠鑷劧鏁?寮濮?
濡傛灉SQL璇彞select * from sometable where rownum >2 涓嶈兘鏌ヨ鍑鴻褰?rownum榪斿洖鐨勬槸false 騫朵笉鑳芥煡璇㈠嚭璁板綍
鎵浠ヨ鐢ㄥ瓙鏌ヨ浜ф垚涓涓猺ownum錛岃繕瑕佺粰rownum浜х敓涓涓埆鍚?
select * form ( select rownum as num ,* from sometable ) where rownum >2
榪欐牱灝卞彲浠ユ煡鍑虹粨鏋滀簡銆傘傘傘備笉榪囨暟鎹噺澶т簡鏁堢巼涓嶆槸寰堥珮 銆?
n-m鐨剆ql璇彞,蹇呴』瑕佹湁涓婚敭
select t2.* from
(
select tmp n-m , t1.* from
(
select top n , t.* from tablename t order by t.F1
)
as t1 order by t1.F1 desc
)
as t2 order by t2.F1