Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
- 3 Answers
- 6698 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / srikanth
select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the difference between a connected look up and unconnected lookup?
How to do the error handling of if ur source is flatfiles?
How identifying bottlenecks in various components of informatica and resolving them?
What is the need for an etl tool?
What you know about transaction control transformation?
Explain sessions?
What is an expression transformation?
What is the Process to creating lookup transformation in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is $$$$?
What is decode in informatica?
What is a repository manager?
What is a transaction control transformation?
