查询出前n条记录的SQL以及Hql语句 好

1. Oracle DB:
Sql: SELECT * FROM user WHERE rownum <=n;
Hql: from User u order by u.salary desc where rownum<=n;

2. SQL Server:
Sql: SELECT TOP n * FROM user;
www.2cto.com
3. MySQL:
Sql: SELECT * FROM Table1 LIMIT n
hibernate查询记录的前10条记录,Hql 不支持limit

Hql: query.setFirstResult(0); // 从第0条记录开始取
query.setMaxResults(10); // 取10条记录

http://blog.sina.com.cn/s/blog_7b4f0c5701014n1a.html