TYPES
Jump to navigation
Jump to search
MIN()Returns the smallest Value
SELECT COUNT(*), SUM(TOTAL_AMOUNT), MIN(TOTAL_AMOUNT) from sales;
Returns the count in one column, the sum of the total_amount column and Min amount
MAX() Returns the largest Value
SUM() Returns the sum of values
SELECT COUNT(*), SUM(TOTAL_AMOUNT) from sales;
Returns the count in one column and the sum of the total_amount column
AVG() Returns the Average of Values
COUNT() Returns the number or rows
SELECT COUNT(*) FROM SALES
Returns the record count