SQL分组
一个SQL[@more@]SELECT rn,COUNT(*) FROM
(SELECT t.Phone, t.Create_Date, b.Rn, b.y_Date
FROM Yzqj4_Molog t,
(SELECT Ceil(Rownum / 30) Rn,
To_Date('2007-08-06 00:00', 'yyyy-MM-dd HH24:mi') +
(Rownum - 1) / 24 / 60 y_Date
FROM Yzqj4_Molog t
WHERE Rownum <= 1 * 24 * 60) b
WHERE To_Char(t.Create_Date, 'yyyy-mm-dd hh24:mi') =
To_Char(b.y_Date, 'yyyy-mm-dd hh24:mi')
AND Cid = '2301'
AND Create_Date > To_Date('2007-08-06 00:00:00', 'yyyy-MM-dd HH24:mi:ss')
AND Create_Date < To_Date('2007-08-07 00:00:00', 'yyyy-MM-dd HH24:mi:ss')) GROUP BY rn;
(SELECT t.Phone, t.Create_Date, b.Rn, b.y_Date
FROM Yzqj4_Molog t,
(SELECT Ceil(Rownum / 30) Rn,
To_Date('2007-08-06 00:00', 'yyyy-MM-dd HH24:mi') +
(Rownum - 1) / 24 / 60 y_Date
FROM Yzqj4_Molog t
WHERE Rownum <= 1 * 24 * 60) b
WHERE To_Char(t.Create_Date, 'yyyy-mm-dd hh24:mi') =
To_Char(b.y_Date, 'yyyy-mm-dd hh24:mi')
AND Cid = '2301'
AND Create_Date > To_Date('2007-08-06 00:00:00', 'yyyy-MM-dd HH24:mi:ss')
AND Create_Date < To_Date('2007-08-07 00:00:00', 'yyyy-MM-dd HH24:mi:ss')) GROUP BY rn;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9925929/viewspace-934376/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
v$recover_file
下一篇：
阿里巴巴笔试题
请登录后发表评论
登录
全部评论
