可是我还要排序呢 select * from cqtb where rownum<5 order by sj desc 结果并没有安我排序得结果取出来前4条纪录
用rownum 如; select * from tname where rownum<20;
可以通过以下方法实现: 取最大的几个值: Select Column1,Column2,Column3.... From (Select Column1,Column2,Column3.... From TableName Order by Column1,Column2,Column3.... Desc) Where RowNum < n;取最小的几个值: Select Column1,Column2,Column3.... From (Select Column1,Column2,Column3.... From TableName Order by Column1,Column2,Column3.... Asc) Where RowNum < n;
where rownum<11
select * from cqtb where rownum<5 order by sj desc
结果并没有安我排序得结果取出来前4条纪录
如;
select * from tname where rownum<20;
取最大的几个值:
Select Column1,Column2,Column3....
From (Select Column1,Column2,Column3.... From TableName Order by Column1,Column2,Column3.... Desc)
Where RowNum < n;取最小的几个值:
Select Column1,Column2,Column3....
From (Select Column1,Column2,Column3.... From TableName Order by Column1,Column2,Column3.... Asc)
Where RowNum < n;
如果是8i或8i以上,你就可以用楼上的办法