SQL SELECT Statement and Mathematical Operations Quiz

TriumphantClearQuartz avatar
TriumphantClearQuartz
·
·
Download

Start Quiz

Study Flashcards

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.

Get started for free
Use Quizgecko on...
Browser
Browser