SQL: FIRST, LAST, MAX, MIN, SUM, GROUP BY, HAVING flash cards

Set: SQL: FIRST, LAST, MAX, MIN, SUM, GROUP BY, HAVING

Term	Definition
SELECT FIRST(column_name) FROM table_name	returns the first value of the selected column
SELECT LAST(column_name) FROM table_name	returns the last value of the selected column
SELECT MAX(column_name) FROM table_name	returns the largest value of the selected column
SELECT MIN(column_name) FROM table_name	returns the smallest value of the selected column
SELECT SUM(column_name) FROM table_name	returns the total sum of a numeric column
SELECT column_name, aggregate_function(column_name)FROM table_name WHERE column_name operator value GROUP BY column_name	used in conjunction with the aggregate functions to group the result-set by one or more columns.
SELECT column_name, aggregate_function(column_name)FROM table_nameWHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value	takes the place of WHERE with aggregate functions

No Messages

Report as inappropriate