这是面试时候的一到题目,当时不会,所以记录一下:
select top 10 * from tb_donation
where id not in(select top 30 id from tb_donation)
或者:select top 10 * from
(select top 10 * from
(select top 40 * from tb_donation order by id desc) as li ) as il
order by id asc
这是面试时候的一到题目,当时不会,所以记录一下:
select top 10 * from tb_donation
where id not in(select top 30 id from tb_donation)
或者:select top 10 * from
(select top 10 * from
(select top 40 * from tb_donation order by id desc) as li ) as il
order by id asc