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 vote226 views1 answer
Opensuse start MySQL
SQL
0 vote193 views1 answer
Check id exist or not in sql
SQL
1 vote235 views1 answer
Order by oracle
SQL
0 vote240 views1 answer
Oracle to_number
SQL
6 votes222 views1 answer
Rank function in oracle with example
SQL
0 vote234 views1 answer
Mariadb used space
SQL
0 vote266 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote239 views1 answer
Database xml sql
SQL
0 vote233 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes233 views1 answer
Get first 2 letter in sql
SQL