SQL语句写法

[dtmyou]

table1:
id column1 column2
1 1 4
2 1 5
3 1 6
4 1 7
5 0 1
6 0 3
7 0 2
其中column1为1或0,
要求得到结果
id column1 column2
1 1 4
2 1 5
5 0 1
7 0 2

[愉快的登山者]

select * from table1 A
where column2 in (select top 2 column2 from table1 where column1 = A.column1 order by column2)

愉快的登山者

⊙
◢◣◢◣◢◣

[pengdali]

select * from table1 tem where id in (select top 2 id from table1 where column1=tem.column1 order by column2)

[dtmyou]

多谢,好笨啊我^_^

数据多的话好像很慢,我还是在程序中分别处理好了...

[CrazyFor]

很慢就给ID,COLUMN2,column1字段加索引.

[CrazyFor]

很慢就给ID,COLUMN2,column1字段加索引.

[hjb111]

crete index i_index on yourtable(id,column2,column1)