Question

Rajis a database programmer. He has to write the query from EMPLOYEE tableto search for the employee who are
not getting any commission for this he has written the query as: SELECT* FROM EMPLOYEE WHERE
commission=null:
But the queryis not producing the correctoutput help Raj and correct the query so that he gets the desired output.​

Answer 1

Answer:

I don't get the line of number 2

Answer 2

Raj has made a small mistake, he must use LIKE clause here instead of using Equal to (=) to get an appropriate output, and the Query must be like :-

SELECT * FROM EMPLOYEE WHERE COMMISSION LIKE NULL;

And this Query will give him an appropriate output.

Hope it Helps.