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
- 12752 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
What is the purpose of using case expression in teradata?
How can we check the version of Teradata that we are using currently?
What are the enhanced features in teradata v2r5 and v2r6?
How many types of joins are there in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
Highlight the differences between Primary Key and Primary Index.
How do you verify a complicated sql?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the available primary index types in teradata.
What is a dimension table?
Highlight the points of differences between the database and user in Teradata.
What is meant by Teradata Gateway?
What is a three-tier data warehouse?
Did you write stored procedures in teradata?
Explain the new features of teradata?
