MSSQL: select top 3 * from article MySQL: select * from article limit 3 Oracle: select * from article where rownum <=3 (好象是这样的...) PostgreSQL: ...不知道,呵呵,请各位补充!
今天在Win2000下装了个PostgreSQL8,试玩了一下,感觉还行,就是不能在特权用户(如Administrator)下运行这点有点不爽,Windows的不安全这是全球旨知的嘛!MSSQL: select top 3 * from article MySQL: select * from article limit 3 Oracle: select * from article where rownum <=3 (好象是这样的...) PGSQL: select top 3 * from article
不让特权用户操作也是为了安全,感觉psql是很好用的,功能挺强大 psql 不支持top吧 ,也是:select * from article limit 3; 如果要某个偏移量的记录要用offset
MySQL: select * from article limit 3
Oracle: select * from article where rownum <=3 (好象是这样的...)
PostgreSQL: ...不知道,呵呵,请各位补充!
MySQL: select * from article limit 3
Oracle: select * from article where rownum <=3 (好象是这样的...)
PGSQL: select top 3 * from article
psql 不支持top吧 ,也是:select * from article limit 3;
如果要某个偏移量的记录要用offset