mysql nested count - how?

Question

Here's the initial query:
SELECT COUNT(column) FROM table GROUP BY column;
This gives me something like the following:
COUNT(column)
2
4
1
1
3
etc.
BUT I need to to count all of those together in one number! How could I do that? COUNT(COUNT(column)) throws an error: "Invalid use of group function".
P.S. this is not used in any program, if it was, it would be trivial to count them together.

Denis de Bernardy · Accepted Answer · 2011-05-25 09:22:06Z

3

remove the group by:

select count(column) from table;

if you need distinct columns:

select count(distinct column) from table; -- might not work in mysql

or:

select count(*) from (select distinct column from table) as columns;

answered May 25, 2011 at 9:22

Denis de Bernardy

79.2k14 gold badges138 silver badges158 bronze badges

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

Comments

Sergio · Accepted Answer · 2011-05-25 09:21:53Z

1

Not sure if this works in mysql: SELECT COUNT(distinct column) FROM table

answered May 25, 2011 at 9:21

Sergio

8,31510 gold badges50 silver badges77 bronze badges

Collectives™ on Stack Overflow

mysql nested count - how?

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