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

5 votes201 views1 answer
Oracle scan source ddl
SQL
3 votes252 views1 answer
RENAME table pl sql
SQL
0 vote231 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote202 views1 answer
Psotgres multiple values
SQL
2 votes234 views2 answers
Mysql show table column comments sql
SQL
21 votes207 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote207 views1 answer
Order by with where clause in mysql
SQL
0 vote152 views1 answer
Update sql join multiple tables
SQL
1 vote203 views2 answers
Mysql join two tables
SQL
0 vote218 views1 answer
Mysql error 1251
SQL