Oracle、SQL Server、MySQL数据库查询前n条语句的语法

一 Oracle DB:

Sql:  

SELECT * FROM user WHERE rownum <=n;

Hql:  

from User u order by u.addTime desc where rownum<=n;

二 SQL Server:

 

 SELECT TOP n * FROM user;

三 MySQL:

Sql:  

SELECT * FROM user LIMIT n

hibernate查询记录的前10条记录,Hql 不支持limit

Hql:  

String hql = "from  user u order by u.addTime asc";  
Query q = session.createQuery(hql);
query.setFirstResult(0);  // 从第0条记录开始取
query.setMaxResults(10); // 取10条记录