/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

57 votes1.4K views5 answers
How to create a new user in postgresql
SQL
1 vote159 views1 answer
Sql padd let with zeros
SQL
0 vote167 views2 answers
Mysql insert into multiple tables
SQL
0 vote199 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
5 votes160 views1 answer
Oracle list packages
SQL
1 vote139 views3 answers
How to filter repeated same result using sql query
SQL
-1 vote159 views1 answer
Default username and password for oracle 11g
SQL
0 vote146 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
1 vote141 views1 answer
Sql auto date
SQL
2 votes161 views5 answers
Eloquest how to select one specific column in database
SQL