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
11230 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 do you mean by tpt in teradata?

1025

Different phases of multiload?

1026

how do you manage the production space. what are the proactive methods you can take ?

1954

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

960

What is upsert statement in teradata?

1143

Explain teradata architecture?

1100

List out all forms of LOCKS that are available in Teradata.

971

What interface is used to connect to windows based applications?

1118

What is the maximum number of dml can be coded in a multiload script?

1113

Describe primary index in teradata?

1005

Define views in teradata with syntax.

1085

How to select first n records in teradata?

1113

What are the uses of client software involved in teradata?

987

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

996

What is logical data model?

1211