一张表排序问题

[cqhweb]

现有一张表如下数据 按最近的时间进行排序，提示： RECEIVE_TIME与SEND_TIME 两个字段中都有可能出现最近的时间。

SMS_ID RECEIVESMS_ID RECEIVE_TIME SEND_TIME
83 2009-05-05 14:37:48.0 null
102 2009-05-17 11:41:44.0
617 null 2009-05-14 21:42:55.0
618 null 2009-05-21 10:46:10.0
.........................

---------排序后结果如下:

SMS_ID RECEIVESMS_ID RECEIVE_TIME SEND_TIME
618 2009-05-21 10:46:10.0
102 2009-05-17 11:41:44.0
617 2009-05-14 21:42:55.0
83 2009-05-05 14:37:48.0

sql怎么写各位大虾?

[hery2002]

TRY

ORDER BY ISNULL(RECEIVE_TIME,SEND_TIME) DESC

[ks_reny]

select * from tb
order by  isnull(RECEIVE_TIME,SEND_TIME)

[ks_reny]

[Quote=引用 2 楼 ks_reny 的回复:]
SQL code
select * from tb
order by isnull(RECEIVE_TIME,SEND_TIME)
[/Quote]
忘了降序。

select * from tb
order by  isnull(RECEIVE_TIME,SEND_TIME) desc 

[SQL77]

学习

[SQL77]

ORDER BY CASE WHEN RECEIVE_TIME IS NULL THEN -SEND_TIME ELSE -RECEIVE_TIME END 

这样不知道行不?

[cqhweb]

你可以试一下..