Fight With Me!!!

导航

主流数据库查找前几条数据的区别

假设从people表查找前五条

mysql:

  select  * from  people  limit 5

sqlserver:

  select top 5   from  people

oracle:

  select  *   from   people where  rownum<5

posted on 2016-03-16 15:44  nickTimer  阅读(237)  评论(0编辑  收藏  举报