🎴 Flashcard Mode
Teradata and SQL Database Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which of the following statements gets the total value of the column 'Price' in the 'Sales' table
AnswerClick to flip back
A
SELECT SUM(Price) FROM Sales
💡 Explanation:
SUM() is the standard SQL aggregate function for calculating the total of numeric values in a column. Option A uses a non-existent ADD() function, Option B uses TOTAL() which is not standard SQL, and Option D is missing the FROM clause.