Nested postgres query

Question

I have two working queries I can't seem to nest.

First one works:

SELECT * FROM accounts WHERE account = 'some_account';

Second works just fine:

SELECT COUNT(*) FROM accounts;

I would like to join these so that I get the count of accounts from the result of the first query and it would look something like this, but I can't do it.

SELECT COUNT(account) FROM (SELECT * FROM accounts WHERE account = 'some_account');

How would I do this?

So you want to know the number of rows where account = 'some_account'? — jarlh
– jarlh, Commented Mar 31, 2016 at 8:14
The bottom one has COUNT(account) where the middle one has COUNT(*), would that make a difference? — Mr Lister
– Mr Lister, Commented Mar 31, 2016 at 8:17
Why not simply select count(*) from accounts WHERE account = 'some_account'? — jarlh
– jarlh, Commented Mar 31, 2016 at 8:19

Matt · Accepted Answer · 2016-03-31 08:18:45Z

1

Either

SELECT COUNT(account) 
FROM (SELECT account 
      FROM accounts 
      WHERE account = 'some_account');

Or

SELECT COUNT(*) 
FROM accounts 
WHERE account = 'some_account';

answered Mar 31, 2016 at 8:18

Matt

15.1k28 gold badges109 silver badges161 bronze badges

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

Comments

S M · Accepted Answer · 2016-03-31 08:20:12Z

1

select count(case when account = 'some_account' then 1 else null end) as Count
FROM accounts

answered Mar 31, 2016 at 8:20

S M

3,2536 gold badges35 silver badges61 bronze badges

Collectives™ on Stack Overflow

Nested postgres query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related