不看会后悔的Windows XP之经验谈	简单快捷DIY实用家庭影院

如何选择id为50-100的记录？

楼主KeepOn（KeepOn）2005-09-01 11:58:18 在 MS-SQL Server / 基础类提问

我想这样，但是50-100的记录没有，不知道行不行，具体应该怎么写？
select * from table where id in (3,4,50-100)

谢谢
问题点数：20、回复次数：9Top

1 楼aw511（点点星灯）回复于 2005-09-01 12:04:38 得分 4

select * from table where id in (3,4)
union
select top 50 * from (select top 100 * from table order by id ) order by id descTop

2 楼vivianfdlpw（）回复于 2005-09-01 12:04:55 得分 3

select * from table where id between 50 and 100Top

3 楼skywebnet（小苯）回复于 2005-09-01 12:05:38 得分 2

select top 50 * from table where id not in (select top 50 id from table )

前提条件是 ID 是唯一的Top

4 楼vivianfdlpw（）回复于 2005-09-01 12:05:53 得分 0

select * from table where (id between 50 and 100)
or id in(3,4)
Top

5 楼hlq8210（影子）回复于 2005-09-01 12:05:58 得分 3

select * from table where id in (3,4,...)and id not in(select Id from table where id
between 50 and 101)
Top

6 楼turenjie（拉倒）回复于 2005-09-01 12:23:04 得分 3

第一种情况:如果是要选择id的值为3,4,50-100
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

Top

7 楼zzxiaoma（小马）回复于 2005-09-01 15:06:24 得分 2

select * from table where id between 50 and 100
Top

8 楼Yisa（）回复于 2005-09-01 16:02:34 得分 3

select * from a where id in(1,3) or id between 5 and 7
Top

9 楼Yisa（）回复于 2005-09-01 16:04:42 得分 0

Sorry,修改下數值.

select * from a where id in(3,4) or id between 50 and 100
Top