不同数据库分页 限制第一条postgreSql、mysql、sqlServer、Oracle总结
postgreSql
后加 limit 1 OFFSET 0
select * from table where name='aaa' limit 1 OFFSET 0
mysql
后加 limit 1
select * from table where name='aaa' limit 1
sqlServer
查询条件前加 top 1
select top 1 * from table
Oracle
where后加 rownum = 1
select * from TABLES where ID>2 and rownum = 1