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

1 vote224 views1 answer
Does insert into overwrite sql
SQL
0 vote208 views1 answer
Postgresql newline character
SQL
2 votes176 views1 answer
Oracle current date without time
SQL
0 vote220 views1 answer
Sub blocks in sql
SQL
0 vote219 views1 answer
Mysql show foreign keys column
SQL
0 vote238 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote263 views1 answer
Install mysql on bash
SQL
1 vote235 views1 answer
Oracle transaction rollback not working
SQL
1 vote240 views1 answer
Top 10 rows in mysql
SQL
-1 vote225 views1 answer
Ssql to lowercqse
SQL