Question

Write MySQL command to select tuples where salary column has some value from emp table
option are
(a)select * from emp where salary=something

(b)select * from emp where salary !=NULL

(c)select * from emp where salary is not NULL

(d)select * from emp where salary # NULL

​

Answer 1

Answer:

The correct option should be (c)select * from emp where salary is not NULL

Explanation:

select* will view all  and where sets a condition which controls the output shown on the screen.