SEL PROD_ID, GREATEST(JAN,FEB,MAR,APR) AS MAX_SALE FROM TABLE

i have a table like sales....the field are

Prodid Jan(jam month sales)Feb March

1 20 76 50
2 30 94 40
3 40 90 30
4 70 20 30
5 23 40 40
6 85 30 55
7 84 20 65
8 10 93 40
9 57 30 30
10 38 83 40
11 35 39 90
12 83 89 50
Now the Question is i want get the max sales of 12 products
from the months.hint:for eg I WANT GET 89 for product12...

Can any one help me

Question Posted / narasimha

8 Answers
10964 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / narasimha

SEL PROD_ID, GREATEST(JAN,FEB,MAR,APR) AS MAX_SALE FROM TABLE_NAME
QUALIFY ROW_NUMBER() OVER (ORDER BY MAX_SALE) =1;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different design perspectives used in teradata?

935

What do you mean by fastexport in teradata?

942

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1728

What is primary index and secondary index?

977

What are the enhanced features in teradata v2r5 and v2r6?

1083

What are the various reporting tools in the market?

991

What is the purpose of joins in teradata and what are the available join types?

1006

What are the different table types that are supported by teradata?

957

What is the difference between global temporary tables and volatile temporary tables?

1087

Describe the set operators in teradata.

956

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2365

What is the meaning of Caching in Teradata?

1084

What is a level of granularity of a fact table?

1076

Explain fallback in teradata?

986

Explain the term 'columns' related to relational database management system?

994