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
Answer Posted / naga
sel t.p,t.jan1, t.col_nm
from (
select p,jan1,'jan1' as col_nm from pm1
union
select p,feb1,'feb1' from pm1
union
select p,mar,'mar' from pm1
)t
qualify rank () over(partition by p order by jan1 desc) =1 order by p;
its bit lengthy but not a complex one..I just
added extra col as col_nm to identify the month name
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain teradata utilities. What is multiload, fast load, tpump?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Can you connect multiload from ab initio?
Comment whether bottleneck is an error or not.
What is node? How many nodes and amps used in your previous project?
What do you mean by tpt in teradata?
What is the maximum number of dml can be coded in a multiload script?
Highlight a few of the important components of Teradata?
What is meant by a Least Cost Plan?
How many tables can you join in v2r5?
What are the steps to create a data model?
What are default access rights in teradata?
What are the different softwares used with their functions in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
if collect stats but it show low confidence why?