select * from table order by id=1,id=3 desc

[decimal_cn]

select * from table order by id=1,id=3 desc
在access中可以正常运行，在sql中就不能得到正确结果，请高人指点

[friendlyFour]

select * from [table]
where id=1 or id=3
order by id desc

[xeqtr1982]

请教楼主这句话在access中的效果。access不太熟

[billpu]

是不是如果id＝1 就把1放在第一行 然后如果id=3就把3放最后一行？

[xeqtr1982]

declare @t table(id int)
insert into @t select 1
insert into @t select 2
insert into @t select 3
insert into @t select 4
insert into @t select 5
insert into @t select 6

select * from @t order by case id when 1 then (select max(id)+1 from @t) when 3 then 0 else id end desc

--去试了一下，不知道是不是这种效果

[yown]

select * from table order by id=1,id=3 desc

==>

select * from table where id=1
union all
select * from table where id=3 order by id desc
union all
select * from table where id not in(1,3)

[云中客]

select * from [table] where id=1 and id=3 order by id desc

楼主,还是把你的问题表达清楚些