write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma
i want the output
id name
101 dinesh
102 suresh
103 prakesh
Answer Posted / a.venkata lakshmi
select id,name from tablename where id in(101,102,103)
Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What is rank transformation in informatica
How do you load alternate records into different tables through mapping flow?
Performance tuning( what you did in performance tuning)
Which is the t/r that builts only single cache memory?
Explain what are the different versions of informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How you prepared reports for OLAP?
Differentiate between reusable transformation and mapplet.
What is Index Caches size?
How to update a particular record in target with out running whole workflow?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the sql query overwrite in source qualifier in informatica
How you know when to use a static cache and dynamic cache in lookup transformation?
Can we create two repositories on same database instance in oracle?
What do you understand by a term domain?