write sql query to filter the null value data following
table?
name age
john 30
smith null
null 34
sharp 24
i want the output following are
name age
john 30
sharp 24
Answer Posted / karthis4u
select * from table name where name is not null OR
age is not null
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
How you can differentiate between connected lookup and unconnected lookup?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Explain target update override in informatica
what is the difference between informatica6.1 and infomatica7.1
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
draw informatica architecture 8.6 ?
Different sorts of metadata that stores in the storage facility?
What are the restrictions of union transformation?
What are the new features of informatica 9.x in developer level?
Explain lookup transformation in informatica
What are the components of the workflow manager?
In warehouses how many schemas are there?
What is the need for an etl tool?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project