Difference between revisions of "TYPES"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
==LAST() Returns the last value of the group== | ==LAST() Returns the last value of the group== | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | |||
Revision as of 23:55, 31 October 2017
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