求一个sql语句？希望大家帮忙！！！

[sea76]

字段 sign 下 先显示 “未完成”的纪录，所有“已完成”的记录在后面显示。sql语句怎样写？

[paoluo]

你的未完成和已完成怎么判断？？

试试

Select * from TableName Order By (Case [sign] When N'未完成' Then 0 Else 1 End)

[edgethinking]

select * from tb where [sign] = '未完成'
union
select * from tb where [sign] = '已完成'

[geniusqing]

select * from tb order by sign desc

[geniusqing]

select * from tb order by sign

[geniusqing]

select * from tb order by sign