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
- 6874 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / brij
select
decode(subject,'maths',mark) maths
,decode(subject,'science',mark) science
,decode(subject,'social',mark) social
from <<table>>
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / keshava
We can use pivot finction on 11g instead of multiple
decodes.
| Is This Answer Correct ? | 0 Yes | 0 No |
what happens if you try to create a shortcut to a non- shared folder?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
how to get max value record into one target and remaining records into another target?
hw cn v elimate dublicate values from lookup without overriding sql?
what are the deliverables?in your project?
What do you mean by enterprise data warehousing?
how lookup is acting as both active and passive ? how is it possitble?
How/where can i install Informatica software with oracle or teradata as database
checkout and checkin in informatica 8.6
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
Teradata 
