GROUP BY postgres

SELECT 
   column_1, 
   column_2,
   ...,
   aggregate_function(column_3)
FROM 
   table_name
GROUP BY 
   column_1,
   column_2,
   ...;
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote109 views1 answer
Mysql random number between 1 and 100
SQL
0 vote247 views1 answer
Power bi connect to postgresql
SQL
0 vote114 views1 answer
Fetching data from mysqldb
SQL
0 vote104 views1 answer
How to output a different column name in mysql
SQL
7 votes108 views3 answers
Postgre describe table
SQL
0 vote104 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote96 views1 answer
Strat with in sql
SQL
1 vote63 views1 answer
How to run sql script
SQL
0 vote100 views1 answer
Change permission to database mysql
SQL
0 vote103 views1 answer
Top frequency in sql server
SQL