28,391
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM
(
SELECT Table1.*,
LatestTime =
CASE
WHEN addtime > updatatime AND addtime > deltime THEN addtime
WHEN updatatime > addtime AND updatatime > deltime THEN updatatime
ELSE deltime
END
FROM Table1
) AS a
ORDER BY a.LatestTime DESC
select * from c order by addtime desc,updatatime desc,deltime desc