1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Answer Posted / guest

Thanks raju......
But i want in a simple manner..


if there is any other way plz let mi know


thanks in advance

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

2898

What is the use of fallback?

558

What is a three-tier data warehouse?

625

What do you mean by tpt in teradata?

587

How do you set the session mode parameters in bteq?

603




Mention a few of the ETL tools that come under Teradata.

616

What is the purpose of joins in teradata?

538

While creating table my dba has fallback or no fallback in his ddl. What is that?

686

How do you see a ddl for an existing table?

569

If a Node is busy what are the steps you can take to avoid ?

1870

What is spool space? Why do you get spool space errors?

510

Explain some differences between mpp and smp?

590

What do you mean by teradata intelliflex?

624

Difference between star and snowflake schemas?

601

What is a node in teradata? Explain

599