我想选择id不同的前两条纪录来显示

[hgxlucky]

我想选择id不同的前两条纪录来显示，我这样写的不行
select top 2 * from photo where id<>id order by id1 desc


ID1 id image ondate title
63 661 cdcatelogo.gif 2004-8-5 8:02:27 zzzzzzzzzz
64 661 foodjob.gif 2004-8-5 8:02:27 zzzzzzzzzz
65 661 hclzlogo.gif 2004-8-5 8:02:27 zzzzzzzzzz
66 662 cdcatelogo.gif 2004-8-5 8:08:44 dddddddddd
67 662 foodjob.gif 2004-8-5 8:08:44 dddddddddd
68 662 logo.gif 2004-8-5 8:08:44 dddddddddd

我想显示id1为68和65的纪录

[yeno]

select top 2 * from (select distinct id from photo) order by id1 desc

[yeno]

写错了
select top 2 * from photo where id in(select distinct id from photo) order by id1 desc

[hgxlucky]

sql="select top 2 * from photo where id in(select distinct id from photo) order by id1 desc"
显示的为id1为67和68的纪录

[yeno]

楼主，你可以给ID1号为66和67的两条记录屏蔽掉嘛
sql="select top 2 * from photo where id in(select distinct id from photo) and id <> '67 and id <>'66' order by id1 desc"

[yeno]

sql="select top 2 * from photo where id in(select distinct id from photo) and id <> '67' and id <>'66' order by id1 desc"

[efei]

如果楼主想取到这两条记录：
63 661 cdcatelogo.gif 2004-8-5 8:02:27 zzzzzzzzzz
66 662 cdcatelogo.gif 2004-8-5 8:08:44 dddddddddd
那么这样：
SELECT * FROM photo WHERE id1 in(SELECT TOP 2 Min(id1) FROM photo group by id)

[jervis82]

好像是在搞sql语句大集合哦，可惜我对此不精。路过。

[hgxlucky]

用efei(草不含羞)的可以，但
sql="select top 2 * from photo where id in(select distinct id from photo) order by id1 desc"
这个就是不行，晕了

[古侠]

谢谢，学习了一招

[pfc001]

select top 2 * from photo where id in(select distinct id from photo) order by id1 desc