Min and Max value across 2 rows

[M_SBS_6]

Hi, 

I have a table with 2 rows and what I want is to see the the min and max time on each row. 

Current output using ID and time with the expected output to include Min time and Max time. 

ID time.      Min time.   Max time

1 11:30:45.   11:30:45.      11:45:36

1 11:45:36.    11:30:45.      11:45:36

Is this possible please? 

[Ahmedx · Accepted solution]

pls try this