Skip to Main Content

SQL Scenario

ArunselvanMar 7 2014 — edited Mar 7 2014

Hi All,

Consider I have one table called customer.

custID    phoneno          Email

1           9999999999     a@gmail.com

2           9999999998     b@yahoo.com

3           Null                 c@gmail.com

Now i need a query to display Phoneno from customer table and if phoneno column is NULL then it should Email column.

Please Help me.

Regards,

Arun

Comments
Post Details
Added on Mar 7 2014
6 comments
198 views