SOLVED: Assume there is a table named EMP with below data: EMPNO EMPNAME ...

Assume there is a table named EMP with below data:
EMPNO EMPNAME LOCATION SALARY (in thousands)
1111 ROHAN BLR 4
1112 SEETHA CHN 5
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN 2

What will be the output of the following query?
SELECT SUM(SALARY) FROM EMP;

ERROR IN DATA, Sum cannot be performed

15

ERROR IN QUERY

17

Verified Answer

Correct Option - d

To get all Infosys Certified L1 Junior Mainframe Programmer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us

Assume there is a table named EMP with below data: EMPNO EMPNAME LOCATION SALARY (in thousands) 1111 ROHAN BLR 4 1112 SEETHA CHN 5 1113 YASINI TVM 3 1114 UMA TVM 3 1115 KIRAN PUN NULL 1116 REENA PUN 2 What will be the output of the following query? SELECT SUM(SALARY) FROM EMP;

Important Links

Assume there is a table named EMP with below data:
EMPNO EMPNAME LOCATION SALARY (in thousands)
1111 ROHAN BLR 4
1112 SEETHA CHN 5
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN 2

What will be the output of the following query?
SELECT SUM(SALARY) FROM EMP;