Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Example data:
- +------+---------------------+---------------------+
- | id | date-time-1 | date-time-2 |
- +------+---------------------+---------------------+
- | 1059 | 2016-07-04 19:13:00 | 2016-07-04 19:20:05 |
- | 1060 | 2016-07-04 19:13:30 | 2016-07-04 19:14:25 |
- | 1061 | 2016-07-04 19:14:39 | 2016-07-04 19:20:05 |
- | 1062 | 2016-07-05 02:34:40 | 2016-07-05 02:45:23 |
- | 1063 | 2016-07-05 02:34:49 | 2016-07-05 02:45:34 |
- +------+---------------------+---------------------+
- Expected result:
- +-------------------------------------------+-------+
- | date-time-1 | date-time-2 | count |
- +-------------------------------------------+-------+
- | 2016-07-04 19:13:00 | 2016-07-04 19:13:29 | 1 |
- | 2016-07-04 19:13:30 | 2016-07-04 19:14:25 | 2 |
- | 2016-07-04 19:14:26 | 2016-07-04 19:14:38 | 1 |
- | 2016-07-04 19:14:39 | 2016-07-04 19:20:05 | 2 |
- | 2016-07-04 19:20:06 | 2016-07-05 02:34:39 | 0 |
- | 2016-07-05 02:34:40 | 2016-07-05 02:34:48 | 1 |
- | 2016-07-05 02:34:49 | 2016-07-05 02:45:23 | 2 |
- | 2016-07-05 02:45:24 | 2016-07-05 02:45:34 | 1 |
- +------+------------------------------------+-------+
- Your query result:
- dtstart dtend count(*)
- July, 04 2016 19:13:00 2016-07-04 19:13:29 1
- July, 04 2016 19:13:30 2016-07-04 19:14:24 2
- July, 04 2016 19:14:25 2016-07-04 19:14:38 1
- July, 04 2016 19:14:39 2016-07-04 19:20:04 2
- July, 04 2016 19:20:05 2016-07-05 02:34:39 1
- July, 05 2016 02:34:40 2016-07-05 02:34:48 1
- July, 05 2016 02:34:49 2016-07-05 02:45:22 2
- July, 05 2016 02:45:23 2016-07-05 02:45:34 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement