ADVERTISEMENT
ADVERTISEMENT

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



ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions


ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.