hi friends
I am having a problem while retriving data from the table;
Actually I want to take the data of the row where column value is null;
e.g.;- select * from emp where name=null;
plz help me.
thnx in advance
Loading
hi friends
I am having a problem while retriving data from the table;
Actually I want to take the data of the row where column value is null;
e.g.;- select * from emp where name=null;
plz help me.
thnx in advance
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj GuptaPosted Dec 18, 2008, 1:12 AM
You can use the "Select * from TABLENAME where COlUMNNAME is null
and for blank use COLUMNNAME like ('');
Abdul AjeesPosted Dec 18, 2008, 12:54 AM
select column from tablename where columnname is null
use is keyword insteadof =