我想选择id不同的前两条纪录来显示
我想选择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的纪录