functions Flashcards Preview

SQL > functions > Flashcards

Flashcards in functions Deck (6)
Loading flashcards...
1

COUNT

takes one argument. Returns the number of rows matching the SELECTion

2

SUM

takes a colunm as argument, returns sum of all values in that column

3

MAX

retuns the row that has the greatest value of argument c1

4

MIN

returns the row that has the smallest value of argument c1

5

AVG

takes a column name and returns the average value of that column

6

ROUND

first argument, value to round, second, number of decimal places to round to (ie 0 is whole number)