通过rownum限制:select * from (select * from goods order by price desc) where rownum<=2
rownum<=2 的效率比较高。
libin_ftsafe(子陌红尘) --你也两版都混,呵呵
select top 2 * from (select * from goods order by price desc)
select * from (select t.* ,row_number()over (order by price desc) seq from goods ) where seq <=2
select * from (select * from goods order by price desc) where rownum<=2; select * from (select * from goods order by price desc) a where rownum<3; select * from (select t.* ,row_number()over (order by price desc) seq from goods ) where seq <=2; 学习ing
select * from dqbm f where f.bm like '15____' AND rownum <3
PL/SQL中没有top 只能用rownum不知道 select * from (select t.* ,row_number()over (order by price desc) seq from goods) a where seq <=2 和 select * from (select * from goods order by price desc) a where rownum<=2 到底谁效率高?
--你也两版都混,呵呵
where seq <=2
select * from (select * from goods order by price desc) a where rownum<3;
select * from (select t.* ,row_number()over (order by price desc) seq from goods )
where seq <=2;
学习ing
select * from (select t.* ,row_number()over (order by price desc) seq from goods) a
where seq <=2
和
select * from (select * from goods order by price desc) a where rownum<=2
到底谁效率高?