常见数据库查询前几条数据
Access,hsql,sql server
select top(10) * from table1 where 1=1
2.db2
select * from table where 1=1 fetch 10rows only
3.Infomix
select first N * from table
常见数据库查询前几条数据
Access,hsql,sql server
select top(10) * from table1 where 1=1
2.db2
select * from table where 1=1 fetch 10rows only
3.Infomix
select first N * from table