SQL中TOP,LIMIT,ROWNUM的用法

SQL SERVER/MS Access的Select Top的用法:

Select TOP number|percent table_columname FROM tablename

MySQL/Oracle的SELECT TOP

Select columname FROM tablename LIMIT number

Select columname FROM tablename WHERE ROWNUM < number。

原文地址:https://www.cnblogs.com/xiangxinhouse/p/6227065.html