/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

-1 vote296 views3 answers
MySQL shutdown unexpectedly
SQL
2 votes279 views1 answer
Mysql clear screen
SQL
1 vote294 views1 answer
Sql server loop over query
SQL
0 vote280 views1 answer
Test sql query
SQL
1 vote280 views1 answer
Psql filed name alter
SQL
0 vote290 views1 answer
Watch mysql command line
SQL
23 votes273 views4 answers
Sql server substring
SQL
4 votes309 views3 answers
Sql find second highest salary employee
SQL
0 vote264 views1 answer
Update set with inner join oracle
SQL
3 votes291 views1 answer
Postgres select max value
SQL