To select tuples with some salary, Siddharth has written the following erroneous SQL statement :

Question

Consider the table’empsalary’

ID	Salary
101	43000
102	NULL
104	56000
107	NULL

To select tuples with some salary, Siddharth has written the following erroneous SQL statement :

SELECT ID. Salary FROM empsalary WHERE Salary = something ; 

Write the correct SQL statement.

Answer 1

The correct code is :

SELECT ID, Salary FROM empsalary

WHERE Salary = 56000 ;