How would you select all the users, whose phone number is null?
rpgwebsolutions
0
Newbie Poster
Recommended Answers
Jump to Postthis is jst eg:
select user from tbname where phnno='null' ;
i assume that you have declared phnno field is null...........
hope this solve your purpose
if this query is not running then send me the table structure
All 2 Replies
preetg
0
Junior Poster in Training
this is jst eg:
select user from tbname where phnno='null' ;
i assume that you have declared phnno field is null...........
hope this solve your purpose
if this query is not running then send me the table structure
darkagn
315
Veteran Poster
Featured Poster
Actually the syntax would be along the lines of:
select * from users where phoneno is null
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.