主流数据库查找前几条数据的区别
假设从people表查找前五条
mysql:
select * from people limit 5
sqlserver:
select top 5 from people
oracle:
select * from people where rownum<5
假设从people表查找前五条
mysql:
select * from people limit 5
sqlserver:
select top 5 from people
oracle:
select * from people where rownum<5