/SQL/Sql count number of rows after group by

Sql count number of rows after group by

Sql count matching group by

# To count the number of teachers in each department, including 
# rows where COUNT(t.name) == 0
SELECT d.name,COUNT(t.name) FROM teacher t
RIGHT JOIN dept d ON (t.dept=d.id) GROUP BY d.name;

Source: sqlzoo.net

Sql count number of rows after group by

Select Count(*)
From    (
        Select ...
        From TempTable
        Group By column_1, column_2, column_3, column_4
        ) As Z

Source: stackoverflow.com

Similar codes

0 vote196 views1 answer
Search mysql database for column
SQL
18 votes197 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
31 votes268 views4 answers
Mysql grant execute
SQL
-1 vote194 views1 answer
How to switch user in mysql
SQL
0 vote200 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote268 views1 answer
How to get number of months between 2 dates sql server
SQL
4 votes185 views1 answer
Id primary key auto generated
SQL
1 vote253 views1 answer
Sample clause in sql
SQL
0 vote239 views1 answer
How to print some string in mysql
SQL
1 vote213 views1 answer
How to run parallel queries in sql server with entity framework
SQL