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 NULL
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN NULL

Identify the correct query to select the employees whose salary is null.

SELECT * FROM EMP WHERE SALARY = NULL;

SELECT * FROM EMP WHERE SALARY IS NULL;

SELECT * FROM EMP WHERE SALARY NOT > 0;

None of the options

Verified Answer

Correct Option - b

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 NULL 1113 YASINI TVM 3 1114 UMA TVM 3 1115 KIRAN PUN NULL 1116 REENA PUN NULL Identify the correct query to select the employees whose salary is null.

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 NULL
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN NULL

Identify the correct query to select the employees whose salary is null.