Which of following is incorrect SQL?
2025
Which of following is incorrect SQL?
Answer: D. Select sum(marks1 , marks2) from student — Ans D Solution Aggregate functions are functions that take a collection (a set or multiset) of values as input and return a single value. The input to sum and…
- A.
Select max(marks) from student
- B.
Select sum(marks) from student
- C.
Select max(marks1 + marks2) from student
- D.
Select sum(marks1 , marks2) from student
Attempted by 952 students.
Show answer & explanation
Correct answer: D
Ans D
Solution
Aggregate functions are functions that take a collection (a set or multiset) of values as input and return a single value.
The input to sum and avg must be a collection of numbers, but the other operators can operate on collections of non-numeric data types, such as strings.
Sum function cannot work on two columns.