HI, >>THE QUERY IS >>SELECT CASE WHEN JAN>FEB AND JAN&

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 / rkraju

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

Answer Posted / rkraju

HI,

>>THE QUERY IS

>>SELECT CASE WHEN JAN>FEB AND JAN>MAR THEN JAN ELSE (CASE
WHEN FEB>JAN AND FEB>M
R THEN FEB ELSE MAR END) END FROM SALES;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the new features of teradata?

1094

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

1011

What is a dimension table?

1104

Explain the term 'primary key' related to relational database management system?

1091

What are the various etl tools in the market?

1125

Difference between inner join and outer join?

1084

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1159

What is stored procedure in teradata?

1090

what are the day to day activities of teradata DBA ?

5861

What are the available primary index types?

1280

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1128

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

902

How do you define Teradata?

1087

What are the commands to make a new table, change a table and remove a table in teradata?

1185

What is the syntax for case when statement?

1218