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
- 6869 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 is data merging,data cleansing,sampling?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
how to get the first row without using rank t/r?
what is the dashbords?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
how to obtain performance data for individual transformations.
How do you update the records with or without using update strategy?
what is parameter file?
what is hash table in informatica?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Teradata 
