47
Which of following is incorrect SQL?
- ASelect max(marks) from student
- BSelect sum(marks) from student
- CSelect max(marks1, marks2) from student
- DSelect sum(marks1, marks2) from student
Answer not set
Discussion 1
Log in or create a free account to reply and vote.
0
CCommunity
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.
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.