TYPES

From rbachwiki
Revision as of 23:55, 31 October 2017 by Bacchas (talk | contribs)
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

FIRST() Returns the first value of the group

LAST() Returns the last value of the group

Back To Top- Home - Category