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
- 2 Answers
- 5685 Views
- HP, I also Faced
- E-Mail Answers
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
What does reusable transformation mean?
if we have a delimiters at unwanted places in a flat file how can we over come those.
I have a flat file, want to reverse the contents of the flat file
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Mention some types of transformation?
Explain the informatica workflow?
Can u generate reports in Informatica?
What are the different types of transformation available in informatica.
What is meant by pre and post session shell command?
How to convert multiple rows to single row (multiple columns) in informatica
How would you copy the content of one repository to another repository?
What are the components of workflow manager?
Define enterprise data warehousing?
What do mean by local and global repository?
