查询第31-40条记录的SQL查询语句:
select * from (select top 40 * from msaleslog order by tno desc ) a where tno not in (select top 30 Tno from msaleslog order by Tno desc ) order by tno desc ;
查询表 msaleslog 的第31-40条记录,按 tno 降序排列。
查询第31-40条记录的SQL查询语句:
select * from (select top 40 * from msaleslog order by tno desc ) a where tno not in (select top 30 Tno from msaleslog order by Tno desc ) order by tno desc ;
查询表 msaleslog 的第31-40条记录,按 tno 降序排列。