How to execute multiples SQL in one QUERY

Asked May 20 '21 at 22:30

Active May 20 '21 at 22:30

Viewed 13 times

I have this:

SELECT count(*) as total_chamadas from ticket WHERE userid = 'root';
SELECT count(*) as total_chamadas_tday from ticket WHERE userid = 'root' AND date(DataCriacao) = CURDATE();

How can I do to execute these two segments and return:

+----------------+---------------------+
| total_chamadas | total_chamadas_tday |
+----------------+---------------------+
|             10 |                   5 |
+----------------+---------------------+

asked May 20 '21 at 22:30

sqlExec

3

`SELECT COUNT(*) AS total_chamadas, SUM(date(DataCriacao) = CURDATE()) AS total_chamadas` – Barmar May 20 '21 at 22:34
1

The gist is to combine your SELECTs and derive them all from the largest set, as Barmer shared above. – zcoop98 May 20 '21 at 22:37
@Barmar thank you! worked very well, i followed the zcoop98 tip also :) – sqlExec May 21 '21 at 18:47

How to execute multiples SQL in one QUERY

0 Answers0