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
Answer Posted / rahul
I agree wth the solution....
but here is the easy way to find the max of sales min of
sales with the two functions that are
greatest and least
the query is
select prodid, greatest(jan,feb,march,apr,may,june,july) as
higher ,
least(jan,feb,march,apr,may,june,july)as low_sales from sales
group by prodid;
Thanks
Rahul
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How many sessions of MAX is PE capable of handling at a particular time?
Why is the case expression used in teradata?
Discuss the advantages of using partitioned primary index in a query?
Explain the term 'columns' related to relational database management system?
Explain the term 'database' related to relational database management system?
What is the maximum number of dml can be coded in a multiload script?
how can we analyze the locks ?
What is the purpose of indexes?
How do you verify a complicated sql?
What are the uses of bynets in multi-node systems?
any one answer me how they can analyzing the project using data ware housing?
Highlight a few of the advantages that ETL tools have over Teradata.
Difference between star and snowflake schemas?
What is multi insert?