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

Answer Posted / rkraju

select case when jan>feb and jan>mar and jan> apr and jan>
may and jan>jun then
jan else (case when feb>jan and feb>mar and feb>apr and
feb>may and feb>jun then
feb else (case when mar>jan and mar>feb and mar>apr and
mar>may and mar>jun then
mar else (case when apr>jan and apr>feb and apr>mar and
apr>may and apr>jun then
apr else (case when may>jan and may>feb and may>apr and
may>mar and may>jun then
may else (case when jun>jan and jun>feb and jun>mar and
jun>apr and jun>may then
jun end)end)end)end)end)end from sales;
i hope this ans fulfill ur req.,

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the advantages of PPI(Partition Primary Index).

559

how many modules are there in telecome domain?how to explain the architecture?

1551

What can be achieved by using the teradata rdbms?

617

What are types of partition primary index (ppi) in teradata?

579

Explain the term 'row' related to relational database management system?

524




What are the various indexes in teradata?

558

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

682

What is meant by a Parsing Engine?

699

What is teradata? What are some primary characteristics of teradata?

541

What are the advantages of teradata?

594

What is meant by a Channel Driver?

638

Explain the advantages of partitioned primary index in a query?

557

How many sessions of MAX is PE capable of handling at a particular time?

587

Which is more efficient group by or distinct to find duplicates?

634

What is real time and near real time data warehousing?

664