;WITH cet AS (
select '2015/9/2' AS D, 3 AS number UNION ALL
select '2015/9/3', 3 UNION ALL
select '2015/9/4', 3 UNION ALL
select '2015/9/2', 1 UNION ALL
select '2015/9/6', 3 UNION ALL
select '2015/9/7', 3 UNION ALL
select '2015/9/2' ,3 UNION ALL
select '2015/9/9', 1 UNION ALL
select '2015/9/9', 3
)
SELECT * FROM cet
ORDER BY d,number
不知道是不是你想要的结果