Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11610 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / hamza
delete id,name from tablename where id='null'
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
How to extract sap data using informatica?
How are the sources and targets definitions imported in informatica designer?
Can anyone tell me the new features in Informatica 9 Version?
difference between informatica 8.1.1 and 8.6
Can informatica load heterogeneous targets from heterogeneous sources?
Explain sessions. Explain how batches are used to combine executions?
have u done any performance tuning? how u ll do?
Explain the types of lookup transformation?
Why filter transformation is an active one?
What is main use of mapplet?
What is different between the data warehouse and data mart?
How can you differentiate between powercenter and power map?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is parallel processing in informatica?
