Home »
Aptitude Questions & Answers »
DBMS Aptitude Questions
SQL Functions Aptitude Questions and Answers | Set 3
List of SQL Functions - Aggregate and Scalar Aptitude Questions
11)
All aggregate function ignore NULL except ______.
- SUM()
- COUNT(*)
- AVG()
- MAX()
Correct Answer - 2
COUNT(*)
12)
Consider the SQL statement
SELECT ROUND(46.32,-1);
What will be the output?
- 50.00
- 46.32
- 46.33
- 46.0