How to combine multiple select statements in postgresql?

Question

I just started learning how to code. I was wondering how to combine multiple SELECT statements in one query.

SELECT count(*) AS "SENT" FROM message_items WHERE status = 'SENT';

SELECT count(*)  AS "NOT SENT" FROM message_items WHERE status = 'NOT SENT';

SELECT count(*) AS "INVALID NUMBER" FROM message_items WHERE status = 'INVALID NUMBER';

Tim Biegeleisen · Accepted Answer · 2019-10-22 09:37:01Z

3

Use conditional aggregation:

SELECT
    COUNT(*) FILTER (WHERE status = 'SENT') AS "SENT",
    COUNT(*) FILTER (WHERE status = 'NOT SET') AS "NOT SENT",
    COUNT(*) FILTER (WHERE status = 'INVALID NUMBER') AS "INVALID NUMBER"
FROM message_items;

If you wanted to generate counts over the entire table, then the above is suitable. If instead you want to generate counts per some other column, then just add that column to the above select clause and then aggregate by that column using GROUP BY.

answered Oct 22, 2019 at 9:37

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Comment

kyle54 Over a year ago

It worked! Thanks for also providing the term so I could read up on it. :D

Lutz · Accepted Answer · 2019-10-22 09:55:41Z

0

You can use GROUP BY

SELECT count(*), status FROM message_items GROUP BY status;

answered Oct 22, 2019 at 9:55

Lutz

6553 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to combine multiple select statements in postgresql?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related