Postgres having

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

6 votes175 views1 answer
How to count number of rows in sql
SQL
0 vote187 views1 answer
Stored procedures example
SQL
0 vote165 views1 answer
Postgresql newline character
SQL
0 vote205 views1 answer
Sql column contains special character
SQL
0 vote169 views1 answer
Show function mysql
SQL
5 votes172 views2 answers
Sql conn
SQL
5 votes233 views2 answers
How to ascending order in sql
SQL
0 vote189 views1 answer
Mysql dump for selected row
SQL
0 vote194 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote182 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL