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
- 11772 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / rama
select id, name from table where id is not null;
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
how many types of dimensions are available in informatica?
What is resilience time?
Explain the informatica workflow?
What is meant by lookup transformation?
Define pmcmd command?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the meaning of decode in informatica?
What are data-driven sessions?
What is the need for an etl tool?
While migrating the data from one environment to another environment how would you manage the connections?
What are the different ways to implement parallel processing in informatica?
How to do the error handling of if ur source is flatfiles?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to Create a folder using pmrep command?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
