PostgreSQL having

SELECT
	column1,
	aggregate_function (column2)
FROM
	table_name
GROUP BY
	column1
HAVING
	condition;

Source: postgresqltutorial.com

Postgres having

SELECT
	customer_id,
	SUM (amount)
FROM
	payment
GROUP BY
	customer_id
HAVING
	SUM (amount) > 200;Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote96 views1 answer
Mysql record group by created date count
SQL
0 vote117 views1 answer
Remove transient options sql wordpress
SQL
3 votes112 views1 answer
How to uninstall microsoft sql server
SQL
4 votes112 views1 answer
Refresh postgres config
SQL
0 vote122 views1 answer
To Create directory
SQL
0 vote96 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote105 views5 answers
Postgresql difference between two dates in days
SQL
6 votes105 views2 answers
What is non relational database
SQL
0 vote105 views1 answer
Get only one row in mysql
SQL
0 vote123 views1 answer
Sql query inline if
SQL