sql在不同数据库查询前几条数据
1. ORACLE
SELECT * FROM TABLE1 WHERE ROWNUM<=N
HQL: from table1 t order by t.createTime desc where rownum<=n
2. INFORMIX
SELECT FIRST N * FROM TABLE1
1. ORACLE
SELECT * FROM TABLE1 WHERE ROWNUM<=N
HQL: from table1 t order by t.createTime desc where rownum<=n
2. INFORMIX
SELECT FIRST N * FROM TABLE1