sql2000中这样的查询语句怎么写?? select *from tborder by isgood,datetime desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tborder by case isgood,datetime desc select * from tb order by isgood desc,[datetime] desc select * from tborder by case isgood,[datetime] desc 不行啊,要 isgood 是1的排在前面,你的刚好相反了,但是我用 asc 还是不行 select * from tb order by isgood desc,[datetime] desc select * from tb order by isgood desc,[datetime] desc select *from tbwhere isgood = 1order by datetime descunion all select * from tbwhere isgood = 0order by datetime desc varchar(50)转换成char(8),好像有点复杂? 我想在此字段自动为每个属性加个货币符号 为何装了瑞星杀毒软件后我创建的维护计划执行失败? 批量建表问题:根据已有表名描述表和字段描述表自动建表 [求助] 在视图中如何根据列值创建新列!! 求助,还原数据库失败~~?? 问一个查询语句 SQLServer的数据库恢复问题? 配置sql邮件的问题 VS 连接到C#出错 在线等。。。。。。。急 非常困惑的问题
order by case isgood,datetime desc
order by case isgood,[datetime] desc
select * from tb order by isgood desc,[datetime] desc
select *
from tb
where isgood = 1
order by datetime desc
union all
select *
from tb
where isgood = 0
order by datetime desc