how to get sql table data from following format

Question

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