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
- 12737 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 is the difference between fastload and multiload?
What is a clique?
What is bteq script in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Highlight the limitations of TPUMP Utility.
What is real time and near real time data warehousing?
List out teradata data types?
If RDBMS is halted what will you do ?
What is meant by a Channel Driver?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How to run a query in teradata?
Syntax for case when statement?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
How can we check the version of Teradata that we are using currently?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
