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
10968 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 teradata primary index mechanics in detail with a diagram.

913

What's the difference between timestamp (0) and timestamp (6)?

1126

Explain teradata utilities?

988

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

916

What is stored procedure in teradata?

960

What are the newly developed features of Teradata?

973

How do you determine the number of sessions?

1010

What type of indexing mechanism do we need to use for a typical data warehouse?

1084

What tools would you use for that?

1032

Why is the case expression used in teradata?

1025

List out some of the primary characteristics of teradata.

929

Where is teradata rdbms used?

1038

Highlight the differences between Primary Key and Primary Index.

1019

What are the different methods ot loading a dimension table? A fact table etc?

980

How do you verify a complicated sql?

1014