I agree wth the solution.... but here is the easy way to find the max of

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

Prodid Jan(jam month sales)Feb March apr may jun july

1 20 76 50 74 94 93 83
2 30 94 40 94 93 93 02
3 40 90 30 49 94 92 56
4 70 20 30 93 46 35 78
5 23 40 40 39 84 46 57
6 85 30 55 93 46 46 46
7 84 20 65 83 56 57 57
8 10 93 40 93 68 57 36
9 57 30 30 83 67 57 79
10 38 83 40 83 55 68 47
11 35 39 90 94 57 78 47
12 83 89 50 93 79 69 69
i wat ti find the max sales of every product which i want to
load into target table

Question Posted / rahul

6 Answers
10861 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / rahul

I agree wth the solution....

but here is the easy way to find the max of sales min of
sales with the two functions that are
greatest and least

the query is

select prodid, greatest(jan,feb,march,apr,may,june,july) as
higher ,
least(jan,feb,march,apr,may,june,july)as low_sales from sales
group by prodid;

Thanks
Rahul

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to identify ppi columns?

1098

What are default access rights in teradata?

1048

List out some of the primary characteristics of teradata.

925

How do you see a ddl for an existing table?

961

What are teradata utilities?

1031

What is stored procedure in teradata?

953

Highlight all the modes that are present under Confidence Level.

915

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

955

What is basic teradata query language?

1029

What are the available primary index types?

1147

What are the string manipulation operators and functions associated with teradata?

1024

How can bottlenecks be identified?

955

What do you mean by teradata intelliflex?

1034

What are the primary characteristics of the Teradata.

1058

What is the command in bteq to check for session settings ?

1114