PostgreSQL SUM The PostgreSQL SUM aggregate function returns the sum value of all rows in a select. SUM syntax SELECT SUM(table_column) FROM table_name; SUM example Goods table id good_type name description price 1 A Car_1 Car 1 description 100 2 A...
PostgreSQL MIN The PostgreSQL MIN aggregate function returns the minimum value in a select. MIN syntax SELECT MIN(table_column) FROM table_name; MIN example Goods table id good_type name description price 1 A Car_1 Car 1 description 100 2 A Car_2 Car 2...
PostgreSQL MAX The PostgreSQL MAX aggregate function returns the maximum value in a select. MAX syntax SELECT MAX(table_column) FROM table_name; MAX example Goods table id good_type name description price 1 A Car_1 Car 1 description 100 2 A Car_2 Car 2...
PostgreSQL AVG The PostgreSQL AVG aggregate function returns the average in a select query. AVG syntax SELECT AVG(table_column) FROM table_name; AVG example Goods table id good_type name description price 1 A Car_1 Car 1 description 100 2 A Car_2 Car 2...
PostgreSQL Count The PostgreSQL COUNT function returns the number of the rows in a select. COUNT syntax SELECT COUNT(*) FROM table_name; SELECT COUNT(column_name) FROM table_name; COUNT example Goods table id good_type name description price 1 A Car_1 Car 1 description 100...