i hope in that above query satisfy ur requirement.for that question can an

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
11231 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / rkraju

i hope in that above query satisfy ur requirement.for that
question can anyone find new query post me
ravikiran.mca.vadali@gmail.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the functions of a Parser?

1121

Explain amp in teradata?

1091

What is called partitioned primary index (ppi)?

1018

what are the uses of fact table and dimension table in banking project?

4560

What is meant by a node?

1047

What is TPD?

1382

What do you mean by fastexport in teradata?

1013

Define views in teradata with general syntax.

1039

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

1779

How can you track login parameters of users in teradata?

1198

What is the purpose of using case expression in teradata?

1024

What is node? How many nodes and amps used in your previous project?

1113

How to select first n records in teradata?

1113

What is upsert statement in teradata?

1143

What are aggregate tables? How do you design them using teradata?

1177