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
- 12605 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Hi,
Below query can be used assuming that there would not be
duplicates of product_names in the parent table and only
three product_names would be the output required.
SEL PRODUCT_ID,MIN(PRODUCT_NAME_1) AS PROD1,MIN
(PRODUCT_NAME_2) AS PROD2,MIN(PRODUCT_NAME_3) AS PROD3
FROM
(SEL PRODUCT_ID,PRODUCT_NAME,
ROW_NUMBER() OVER (PARTITION BY PRODUCT_ID ORDER BY
PRODUCT_NAME ASC) AS PRODRANK,
CASE WHEN PRODRANK=1
THEN PRODUCT_NAME END AS PRODUCT_NAME_1,
CASE WHEN PRODRANK=2
THEN PRODUCT_NAME END AS PRODUCT_NAME_2,
CASE WHEN PRODRANK=3
THEN PRODUCT_NAME END AS PRODUCT_NAME_3
FROM PRODUCT) A
GROUP BY 1;
If the above case is numeric, SUM should be used instead of
MIN.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
In BTEQ, how are the session-mode parameters being set?
Explain the meaning of Amp?
What are the steps to create a data model?
What are the scenarios in which full table scans occurs?
What is spool space? Why do you get spool space errors?
Explain vproc in teradata?
How to find duplicates in a table?
What is stored procedure in teradata?
Explain fastload in teradata?
What are teradata utilities?
What are the different table types that are supported by teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Syntax for case when statement?
What are the various indexes in teradata? How to use them?
