select * from table where id in (3,4)
union
select top 50 * from (select top 100 * from table order by id ) order by id desc
union
select top 50 * from (select top 100 * from table order by id ) order by id desc
or id in(3,4)
between 50 and 101)
select * from 表 where id in (3,4) or id between 50 and 100
第二种情况:如果是要选择表中,第3,4行,及第50-100行
select top 2 * from (select top 4 * from table order by id ) order by id desc
union
select top 50 * from (select top 100 * from table order by id ) order by id desc