Postgresql Min Max. If we want to get the minimum salary and deduction from employee table the following sql can be used. Fortunately there is a simple.
The above given postgresql statement will produce the following result. Since min max and count are defined using a generic api for aggregate functions there is no provision for special casing the execution of these functions under certain circumstances. Select min salary minimum salary min deduction minimum deduction from employee.
For example you can use the max function to find the employees who have the highest salary or to find the most expensive products etc.
For example there are aggregates to compute the count sum avg average max maximum and min minimum over a set of rows. Postgresql cannot easily implement this optimization because it also allows for user defined aggregate queries. The syntax of the max function is as follows. You can use the min function along with the max function to find out the minimum value as well.
