/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

4 votes167 views1 answer
Postgresql show current database
SQL
0 vote180 views1 answer
MySQL FIND_IN_SET()
SQL
8 votes172 views1 answer
Mac restore mysql database command line
SQL
0 vote186 views1 answer
Get a list of tables and the primary key
SQL
0 vote184 views1 answer
Flush user resource mysql
SQL
2 votes175 views1 answer
Oracle list grants on procedure
SQL
0 vote183 views1 answer
Convert rows into columns in oracle
SQL
5 votes176 views1 answer
How to check nls format in oracle
SQL
1 vote187 views2 answers
How to search date in sql query
SQL
0 vote240 views1 answer
Trigger
SQL