Select SQL statement on same column

Question

I want to select distinct count(id) as activeusers from a table where useractive=1, but at the same time I want to select all the users example distinct Count(id) as totalusers regardless of activestate. How to achieve this in a SQL query?

Hello, you want to query twice the same table, so you need to use a joined query. Select count(table1.id) as totalusers, count(table2.id) from mytable table1, mytable table2 where table2.useractive = 1 There are other prettier solutions — Amandine FAURILLOU
– Amandine FAURILLOU, Commented Jun 18, 2024 at 7:26

Mureinik · Accepted Answer · 2024-06-18 07:23:33Z

2

You could call count over a case expression:

SELECT COUNT(DISTINCT CASE useractive WHEN 1 THEN id END) AS active_users,
       COUNT(DISTINCT id) AS total_users
FROM   mytable

answered Jun 18, 2024 at 7:23

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

Select SQL statement on same column

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