Postgresql Average Example - Sql

How to find average value of an expression in SQL query?

Snippet Code

Rate this page :
  [ 0 votes]

Postgresql is an AVG function which gets the average of all selected values of records. Simple code to find the average value of an expression is given below

Syntax: -------- SELECT avg(aggregate_expression) FROM tables WHERE conditions; Example: ---------- SELECT status_type, AVG(vote) FROM rating;


Ask Questions

Ask Question