数据库中只取前多少行记录的sql语句,下面是一些例子,本人经常用到的是Oracle和db2
1. ORACLE (亲测)
SELECT * FROM TABLENAME WHERE ROWNUM<=N
2. INFORMIX
SELECT FIRST N * FROM TABLENAME
3. DB2 (亲测)
SELECT COLUMN FROM TABLENAME FETCH FIRST N ROWS ONLY
4. SQL SERVER
SELECT TOP N * FROM TABLENAME
5. SYBASE
SET ROWCOUNT N
GO
SELECT * FROM TABLENAME
6. MYSQL
SELECT * FROM TABLENAME LIMIT N
7. FOXPRO
SELECT * TOP N FROM TABLENAME ORDER BY COLUMN
8.postgres查询前几条记录SQL
SELECT * FROM TABLENAME LIMIT
hibernate查询记录的前10条记录(注意:order by newid()是指每次排序都是随即的)
String hql="select * from tablename t where t.id1=? and t.id2=? order by newid()";
//创建查询对象
Query query = this.getSession().createQuery(hql);
//对查询语句进行赋值
query.setParameter(0,id1);
query.setParameter(1,id2);
//设置起始行数和最大查询行数
query.setFirstResult(0);//从第0条开始取
query.setMaxResults(10);//取十条记录
return query.list();