/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 vote159 views1 answer
Get created time of database psql 8
SQL
27 votes154 views3 answers
Mysql show tables in database
SQL
0 vote142 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote155 views1 answer
Sql server current time without date
SQL
8 votes145 views2 answers
Python simple connect to mysql
SQL
0 vote138 views2 answers
Create row number in sql
SQL
0 vote104 views1 answer
Mysql offset from bottom
SQL
57 votes323 views6 answers
Mysql alter table add column
SQL
12 votes128 views3 answers
Install sqlite driver ubuntu
SQL
8 votes198 views2 answers
Oracle auto increment primary key
SQL