数据库查询前10条比较

SQLServer:select  top 10 * from mytable;

Oracle: select * from mytable where rownum <=10;

Mysql:select * from mytable limit 0,10;

PostgreSQL:select * from mytable limit 0,10;(貌似跟Mysql一样的)

posted @ 2020-03-29 12:34  JackGIS  阅读(468)  评论(0编辑  收藏  举报