mysql start and end date for contiguous dates in multiple rows

Asked May 21 '21 at 18:41

Active Jun 21 '21 at 23:07

Viewed 59 times

My schedule table

ID	UserID	Date	status
1	1	2021-01-03	vacation
2	1	2021-01-04	vacation
3	1	2021-01-05	present
4	2	2021-01-01	present
5	2	2021-01-02	vacation
6	2	2021-01-03	vacation
6	2	2021-01-04	vacation
6	2	2021-01-05	present
7	2	2021-01-07	vacation

But I need to get output like this.

UserID	Start	End	status
1	2021-01-03	2021-01-04	vacation
2	2021-01-02	2021-01-04	vacation
2	2021-01-07	2021-01-07	vacation

edited Jun 21 '21 at 23:07

ysth

asked May 21 '21 at 18:41

Santosh Khanal

where does the ID in your desired results come from? – ysth May 21 '21 at 18:45
you are only looking for status='vacation'? – ysth May 21 '21 at 18:46
do show what you tried, please – ysth May 21 '21 at 18:47
@ysth The desired result don't need any id, sorry for that It just needs userID, startDate, endDate, status – Santosh Khanal Jun 21 '21 at 21:50
what does `select version();` show? – ysth Jun 21 '21 at 23:06
and again, please show what you tried; it will reveal important information about what you are trying to accomplish that just the text you provide does not. – ysth Jun 21 '21 at 23:13

0 Answers0