Question

Please solve the following sql database question :-

Answer 1

The correct statement would be:

Select EID, ESalary from EMPSALARY from ESalary is not Null;

The statement given by Arun would result in an error, as there is no clause/keyword called 'something'. To indicate that we want records with values in them, we use 'is not Null'.

Since SQL isn't a case-sensitive language, it doesn't matter what case you used to type it.

Likewise, to indicate that we want records with Null values in them, we use 'is Null'.

Keep in mind that we DO NOT use the equal to (=)/not equal to (!=) symbol along with Null.

For example, Select EID, ESalary from EMPSALARY from ESalary != Null; would result in an error.