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。
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