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
- 11576 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
How we can create indexes after completing the loan process?
Explain what are the different versions of informatica?
Global and Local shortcuts. Advantages.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the meaning of decode in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are session parameters ? How do you set them?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What all are steps in up gradation of Informatica server?
What are the prerequisite tasks to achieve the session partition?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the difference between informatica 7.0 and 8.0?
Explain joiner transformation in informatica
How to configure mapping in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
