Hi friends
the following is the actual format in table period_details
PeriodNo StartTime EndTime
1 09:00 10:00
2 10:01 11:00
3 11:10 12:10
4 12:11 01:10
5 02:01 03:00
6 03:01 04:00
L 01:11 02:00
but i want to select as
follows
PeriodNo StartTime EndTime
1 09:00 10:00
2 10:01 11:00
3 11:10 12:10
4 12:11 01:10
L 01:11 02:00
5 02:01 03:00
6 03:01 04:00
How to write a query for this view