| ○access： selecttop(10...... access： select top (10) * from table1 where 1=1 db2： select column from table where 1=1 fetch first 10 rows only mysql： select * from table1 where 1=1 limit 10 sql server: 读取前10条：select top (10) * from table1 where 1=1 读取后10条：select top (10) * from table1 order by id desc 在sqlserver里面，如何读取按照某个排序，第5到10这五个记录 select top 6 * from table where id not in(select top 4 id from table) oracle： select * from table1 where rownum<=10 |
|小黑屋|最新主题|手机版|微赢网络技术论坛
( 苏ICP备08020429号 )
GMT+8, 2024-9-30 09:34 , Processed in 0.109653 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.
