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
- 6856 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
Explain what are the different versions of informatica?
Which development components of informatica have the highest usage?
How many types of sessions are there in informatica.please explain them?
What is a passive transformation?
What are session parameters ? How do you set them?
Explain the types of lookup transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the different versions of informatica?
Explain incremental aggregation in informatica
what is the size of your data warehousing?
What do you mean by enterprise data warehousing?
what is $$$$?
Write the unconnected lookup syntax and how to return more than one column.
What is the session task and command task?
What are the limitations of joiner transformation?
