你若不排序的话,直接:
select * from yourtable where rownum <= 30若要按照每个字段排序的话(假设为ID)
select * from (select * from yourtable order by id) where rownum <= 30可以去搜索ROWNUM看看
select * from yourtable where rownum <= 30若要按照每个字段排序的话(假设为ID)
select * from (select * from yourtable order by id) where rownum <= 30可以去搜索ROWNUM看看
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货