I am using below query, do I need to use join?Please suggest
Code: Select all
SELECT min(TIMESTAMPDIFF('ss',submission_time,start_time))as Min_Wait_time from time
union
SELECT max(TIMESTAMPDIFF('ss',submission_time,start_time))as Max_Wait_time from time
union
SELECT avg(TIMESTAMPDIFF('ss',submission_time,start_time))as Avg_Wait_time from time
union
SELECT median(TIMESTAMPDIFF('ss',submission_time,start_time)) over() as Median_wait_time from time
union
I am getting the output like:
Min_Wait_time
16.159641811159
5.0
0.0
115431.0
3737.53128
The output should be like:
Min_Wait_time Max_Wait_time Avg_Wait_time Median_wait_time
0.0 115431.0 16.159641811159 5.0