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
- 11769 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
What is data transformation manager process?
What do you mean by blocking transformation?
where to store informatica rejected data?
What are the restrictions of union transformation?
Explain what is informatica metadata and where is it stored?
What are the limitations of joiner transformation?
How many ways are there to do 'remove duplicate records in informatica'?
How many types of sessions are there in informatica.please explain them?
Explain in detail about scd type 1 through mapping.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the various types of transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Mention few power centre client applications with their basic purpose?
What is different between the data warehouse and data mart?
Explain scd type 3 through mapping.
