22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT MIN(ServerTime) AS ServerTime, X, Y
FROM Wow_PhoneDate
where (Mini = '123456789223456') AND (CONVERT(varchar(10), ServerTime, 23)
= '2009-09-24')
GROUP BY DATEPART(hh, ServerTime), X, Y, Mini
SELECT MIN(ServerTime) AS ServerTime, X, Y
FROM Wow_PhoneDate
GROUP BY DATEPART(dd, ServerTime), X, Y, Mini
HAVING (Mini = '123456789223456') AND (CONVERT(varchar(10), ServerTime, 23)
= '2009-09-24')
SELECT * FROM TB T WHERE NOT EXISTS
(SELECT * FROM TB WHERE
CONVERT(VARCHAR(10),TIME,120)= CONVERT(VARCHAR(10),T.TIME,120) AND DATEPART(HH,TIME)<DATEPART(HH,T.TIME))
最好给出表结构,测试数据,计算方法和正确结果.