帮忙写一个order by 语句，非常感谢

nply2008 2009-04-10 04:31:32

id time tip
1 2008-4-8 1
2 2008-4-8 1
3 2008-4-5 1
4 2008-4-2 1
5 2008-4-5 1

查询结束是：

id time tip
2 2008-4-8 1
1 2008-4-8 1
5 2008-4-5 1
3 2008-4-5 1
4 2008-4-2 1

这个查询怎么写，想了好久

...全文

104 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

IDNCC 2009-04-12

打赏
举报

order time desc,id desc

caohao 2009-04-12

打赏
举报

SELECT *　FROM T
ORDER BY time DESC,id DESC

caosir157880 2009-04-11

打赏
举报

SELECT *
FROM T
ORDER BY time DESC,id DESC

moonshineidolon 2009-04-10

打赏
举报

大写小写都一样的

SELECT *
FROM T
ORDER BY time DESC,id DESC

sumaoyi 2009-04-10

打赏
举报

也改下大小写

liangCK 2009-04-10

打赏
举报

---------------------------------

--  Author: liangCK 小梁

---------------------------------

 

--> 生成测试数据: @T

DECLARE @T TABLE (id INT,time DATETIME,tip INT)

INSERT INTO @T

SELECT 1,'2008-4-8',1 UNION ALL

SELECT 2,'2008-4-8',1 UNION ALL

SELECT 3,'2008-4-5',1 UNION ALL

SELECT 4,'2008-4-2',1 UNION ALL

SELECT 5,'2008-4-5',1



--SQL查询如下:



SELECT *

FROM @T

ORDER BY time DESC,id DESC



/*

id          time                    tip

----------- ----------------------- -----------

2           2008-04-08 00:00:00.000 1

1           2008-04-08 00:00:00.000 1

5           2008-04-05 00:00:00.000 1

3           2008-04-05 00:00:00.000 1

4           2008-04-02 00:00:00.000 1



(5 行受影响)





*/