/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

2 votes317 views1 answer
Oracle find constraints referencing a table
SQL
0 vote250 views2 answers
Avg() sql
SQL
1 vote280 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote293 views1 answer
Alter column to not null with default value sql server
SQL
0 vote307 views1 answer
Sql server for loop
SQL
6 votes276 views4 answers
How to remove unique key in mysql
SQL
0 vote300 views1 answer
How to print sql query
SQL
1 vote282 views1 answer
Sql server select rows by distinct column
SQL
1 vote289 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
6 votes288 views2 answers
Mysql interval 1 day
SQL