MySQL combining two count statements

Question

I have two different MySQL count queries like this:

SELECT COUNT(*) AS stored_counter FROM users WHERE ***

SELECT COUNT(*) AS total_taken FROM completed WHERE ***

I'm looking for if the count value of query 1 matches the count value of query 2. Right now I am running these two queries seperately via PHP and then using PHP to see if the two queries return the same values.

But i'm looking to see if it's possible to do this with 1 SQL query?

Thanks

nbk · Accepted Answer · 2020-06-14 15:37:55Z

1

You can use this form

SELECT
(SELECT COUNT(*)  FROM users WHERE 1 =1) stored_counter,
(SELECT COUNT(*) FROM completed WHERE 1=1)  total_taken

You can add every Select statement that only gives back one Result (one field(one row one column)) only) as its own column

answered Jun 14, 2020 at 15:37

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL combining two count statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related