6 Questions
What SQL keyword is used to find the total for a column?
SUM
Which statement is used to identify which columns will be displayed in SQL output?
Select
When multiple conditions need to be linked in SQL, what statement is used?
AND
Which SQL keyword is used to find the lowest amount in a column?
MINIMUM
What is the purpose of the GROUPBY keyword in SQL?
To calculate subtotals
In SQL, what statement is used to sort the output in either ascending or descending order?
ORDERBY
Test your knowledge on using the SELECT statement in SQL to choose columns for output and performing mathematical operations like SUM, MINIMUM, MAXIMUM, COUNT, and AVERAGE on column data. Learn how to create new fields for queries using mathematical operations.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.