SQL Functions Aptitude Questions and Answers | Set 3

List of SQL Functions - Aggregate and Scalar Aptitude Questions

11) All aggregate function ignore NULL except ______.
  1. SUM()
  2. COUNT(*)
  3. AVG()
  4. MAX()

12) Consider the SQL statement
SELECT ROUND(46.32,-1);
What will be the output?
  1. 50.00
  2. 46.32
  3. 46.33
  4. 46.0





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.