Sql

-- Classes with more than 10 students
SELECT student_class, COUNT(*) FROM students GROUP BY student_class 
	HAVING count(*) > 10;

SELECT COUNT(customer_id), country
FROM Customers
GROUP BY country
HAVING COUNT(customer_id) > 1;

PREVIOUS	NEXT

Code Example
Sql :: mssql find deadlocks
Sql :: create table sqlite
Sql :: allsource oracle
Sql :: coalesce postgresql
Sql :: postgres group by 10 minute intervals
Sql :: sql delete caracter list
Sql :: create index concurrently postgres
Sql :: mysql backup query
Sql :: SQL loop with cursor
Sql :: change postgress password
Sql :: input in mysql
Sql :: how to get id of last inserted row in mysql
Sql :: rename constraint postgresql
Sql :: oracle difference between two dates in seconds
Sql :: mysql ifnull
Sql :: grant all privileges on a db
Sql :: how to print mysql query of codeigniter query builder
Sql :: permission denied postgres copy csv command line
Sql :: SQL Auto Increment Primary Key - SQL Server
Sql :: postgres cast as currency format
Sql :: sql column contains special character
Sql :: mysql cashing error
Sql :: mysql on duplicate key update
Sql :: 3 days back in sql server
Sql :: sql stored procedure with output parameters
Sql :: mysql get last insert id
Sql :: postgres show databases
Sql :: mysql alter add foreign key
Sql :: postgres : ERROR: division by zero
Sql :: oracle apex warning message