求SQL语句~!!!!!!!!!!!!!!!!!!!!!

select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 else id end

select * from 解答咨询表 order by 解答人姓名,case when 解答人姓名='admin' then 0 else id end
楼上的,要是admin这个值不止一个呢？是不是这样写也有问题呀？
select 解答人姓名,sum(解答数量) from 解答咨询表 group by 解答人姓名 order by 解答人姓名,case when 解答咨询表='admin' then null else uname end
To freedom:
select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 else id end
是對的,但是有個問題啊:
不是admin的是按id升序排列的,若我改為
select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 else id desc end
會報錯,不知道如何改啊?
--try
select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 else id  end desc
try:
select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 end，id desc
to iwl()
你那样的话！
admin 不就排到最后了啊！??
select * from 解答咨询表 order by case when 解答人姓名='admin' then 0 else 1 end，id desc
select 解答人姓名,sum(解答数量) from 解答咨询表 group by 解答人姓名 order by 解答人姓名,case when 解答咨询表='admin' then null else uname end
select * from 解答咨询表 order by case 解答人姓名 when 'admin' then 0 else 1 end,id desc
------------应该是可以的，偶测试通过