Interested to Buy Any Domain ? << Click Here >> for more details...
Hello Frndz,
I have a table named product as shown below:
product_id product_name
1 AAA
1 BBB
1 CCC
2 PPP
2 QQQ
2 RRR
Now my output should be:
product_id product_name_1 product_name_2 product_name_3
1 AAA BBB CCC
2 PPP QQQ RRR
- 4 Answers
- 12610 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vishvajeet mistry
We can also use Full outer join in this case.
sel
t1.pid,
t1.pn as pn1,
t2.pn as pn2,
t3.pn as pn3
from
(sel pid,pn
from prod
qualify rank() over (partition by pid order by pn)=1)t1
Full outer join
(sel pid,pn
from prod
qualify rank() over (partition by pid order by pn)=2)t2
On
t1.pid=t2.pid
Full outer join
(
sel pid,pn
from prod
qualify rank() over (partition by pid order by pn)=3)t3
on
t1.pid=t3.pid
order by 1 ;
Hope it helps :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are default access rights in teradata? What explicit right can be given to a user?
What is the meaning of Caching in Teradata?
What are the things to be considered while creating secondary index?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is the difference between union and union all in teradata?
What are the joins in teradata?
What is basic teradata query language?
Steps to create a data model?
How to find duplicates in a table?
How many codd's rules are satisfied by teradata database?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is meant by a Highest Cost Plan?
List out teradata data types?
What are teradata utilities?
Describe the between keyword in teradata?
