TOP 子句用于规定要返回的记录的数目,下面是不同数据库top的用法
mySQL用法:select * from table LIMIT 1
oracle用法:select * from table where rownum=1
sqlserver用法:select top 1 * from table
mySQL用法:select * from table LIMIT 1
oracle用法:select * from table where rownum=1
sqlserver用法:select top 1 * from table