Posts

Showing posts with the label Aggregation Functions(Avg / Count / Max / Min / Sum)

7 - SQL Aggregation functions

Image
  Aggregation Functions Avg()         :      Returns the average value from specified columns Count()     :        Returns number of table rows Max()       :       Returns largest value among the records Min()        :      Returns smallest value among the records Sum()      :     Returns the sum of specified column values ...........................................................                                   ORIGINAL LIST Find the maximum salary out of the list using SQL Aggregation Functions select   max (salary) from employees ; Find the minimum salary out of the list using SQL Aggregation Functions select   min (salary) from employees ; Find the average salary  of the list using SQL Aggregation F...