查询数据时,要求每次返回20行,SQL语句应如何写
------解决方案--------------------------------------------------------
select * from tabname fetch first 20 rows only
------解决方案--------------------------------------------------------
row number() over() as rn
------解决方案--------------------------------------------------------
select top 20 * from tabname
where id not in(select top 10 id from tabname)
------解决方案--------------------------------------------------------
rank() over (colum1 desc)
也可以。