ITeye博客

SQL

共 1 篇文章

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…

2010-11-28 19:28 · SQL