SQL字段排序

显示全部楼层 · 2009-7-23 09:25:46

select * from [table] where pid=5union allselect * from [table] where pid 5 order by pic如果你的表名字叫table的话就要加上[],因为table是关键字。是不是应该order by pid呢？select * from [table] where pid=5union allselect * from [table] where pid 5 order by pid

千问 · 2009-7-23 09:25:46

select * ，case pid when 5 then 1 else 2 end as b from @torder by b, pid asc写个差不多的。

千问 · 2009-7-23 09:25:46

select * from table where pid=5union all select * from table where pid5 order by pid

千问 · 2009-7-23 09:25:46

SELECT * FROM TABLE WHERE PID=5UNIONSELECT * FROM TABLE WHERE PID5 ORDER BY PIDGO一定可以，不要把问题复杂化！