Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 11403 Views
- Satyam, I also Faced
- E-Mail Answers
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
What is the basic syntax for teradata select statement?
How is the teradata different from oracle?
What are the different methods ot loading a dimension table? A fact table etc?
What are the string manipulation operators and functions associated with teradata?
How many types of joins are there in teradata?
What are the frequently used data types in teradata?
What is a node in teradata?
Explain PDE.
How would you load a very large file in teradata in general?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the difference between union and union all in teradata?
Differentiate database data and data warehouse data?
how do you manage the production space. what are the proactive methods you can take ?
What are the available join types in teradata?
