各数据库取前十条数据的方法
各数据库取前十条数据的方法db2: www.zzzyk.comselect * from tab fetch first 10 rows onlyoracle:select * from tab where rownum <=10sqlserver:select top 10 * from tabmysql:select * from tab limit 10
各数据库取前十条数据的方法db2: www.zzzyk.comselect * from tab fetch first 10 rows onlyoracle:select * from tab where rownum <=10sqlserver:select top 10 * from tabmysql:select * from tab limit 10