My query giving the syntax error.please suggest
Code: Select all
SELECT count(job_number),median(TIMESTAMPDIFF('ss',submission_time,start_time)) as median from acctn;
Moderator: NorbertKrupa
Code: Select all
SELECT count(job_number),median(TIMESTAMPDIFF('ss',submission_time,start_time)) as median from acctn;
Code: Select all
SELECT count(job_number) OVER() as job_number_count,median(TIMESTAMPDIFF('ss',submission_time,start_time)) OVER() as median from acctn LIMIT 1;