SQL语句 查询N条记录
SQL在Oracle、SQLServer、MySQL上查询前N条数据1、ORACLE
SQL：SELECT*FROMTableNameWHEREROWNUM<=N
HQL：FROM TableName TORDERBY T.createTimeDESC WHERE ROWNUM <=n
HQL注解：HQL 是Hibernate Query Language的简写，即 hibernate 查询语言
2、SQLServer
SQL：SELECT FIRST N * FROM tablename
3、MySQL
SQL：SELECT * FROM TableName LIMIT N
4、DB2
SQL：SELECT*ROW_NUMBER()OVER(ORDERBYCOL1DESC)ASROWNUMWHEREROWNUM<=N
页:
[1]