Courses

NULL value

Dear Sir
The salary column (float data type) of one column is set as NULL. But the following query returns null value
select * from users where salary=NULL;
Please let me know what is wrong in the above query
With Thanks and regards
Sandhya

Asked by Sandhya Ramakrishnan | Oct 3, 2012 | Reply now

Replies (1)

amit kumar goswami

select * from users where salary=NULL

this query return record from users table where salary equals

to zero means row where you not enter any salary that will

return

Oct 4, 2012

Reply now

Java Developer
J2EE Web Developer
SAS
.NET Developer
CAT
Oracle DBA
Software Testing

All courses

Courses

NULL value

Forum By Category