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 vote364 views1 answer
View t-sql mail configuration
SQL
1 vote342 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote336 views1 answer
Sql server update top n records
SQL
0 vote357 views1 answer
Implicit inner join table alias
SQL
0 vote412 views1 answer
Remove mysql from centos 7
SQL
4 votes344 views1 answer
Oracle select first 10 rows
SQL
0 vote310 views1 answer
Import sql mysql ubuntu
SQL
0 vote368 views1 answer
How to find symmetric pairs in sql
SQL
4 votes333 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote362 views1 answer
Sql mod even odd
SQL