50 分求一 sql server 表达式

alanleefeng 2003-11-27 02:16:46

一表 "news" 包括 "type“，“input_time“列，要将每一个type按新旧顺序组成一个表。
我尝试以下算法，sql2000中都不对,sql7.0 中 the first one is right。
select * from (select * from news order by input_date desc) middata order by type;
select * from (select * from news order by type) middata order by input_date desc;

...全文

51 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

alanleefeng 2003-12-01

打赏
举报

hi, pengdali, you just got the same answer as mine, but it doesn't works well on ms sql server 2000.
Other answers are all incorrect absolutely.
thanks for replying, mates.
Any other guru here?

dlpseeyou 2003-12-01

打赏
举报

来迟了!

shuiniu 2003-12-01

打赏
举报

-- bad sql(i think so)
select * from (select * from news order by input_date desc) middata order by type;
select * from (select * from news order by type) middata order by input_date desc;

try:
select * from news order by type,input_date desc

Benimarunikado 2003-11-27

打赏
举报

楼主，你的语法是错误的！

select * from news order by input_date desc, type
GO
select * from news order by type,input_date desc
GO
命令已成功完成。

pengdali 2003-11-27

打赏
举报

select * from news order by input_date desc,type;
select * from news order by type,input_date desc;

txlicenhe 2003-11-27

打赏
举报

select * from news order by type,input_date desc

pengdali 2003-11-27

打赏
举报

select * from (select top 999999999 * from news order by input_date desc) middata order by type;
select * from (select top 999999999 * from news order by type) middata order by input_date desc;