Interview Questions
Q.

Identify error in following SQL: SELECT EMPNO, SUM(SAL) FROM EMP GROUP BY EMPNO HAVING ENAME= ?KENT? a) Syntax Error b) SUM() is not an aggregate function c) HAVING can not be used with GROUP BY d) The Having condition has to be based on some column that

 


Answer :
Post Answer :  
Answer * :
Are You? Already a Member New User
   
User Name / Email * :
Password * :
Security Code * :

(Enter security code above shown on image)