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
- 6 Answers
- 10070 Views
- Satyam, I also Faced
- E-Mail Answers
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
Is multi insert ansi standard?
Explain fastload in teradata?
Explain parsing engine in teradata?
Highlight the limitations of TPUMP Utility.
Name the five phases that come under MultiLoad Utility.
What is the basic syntax for teradata select statement?
How can you track login parameters of users in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the term 'foreign key' related to relational database management system?
What is meant by a Least Cost Plan?
What is the command in bteq to check for session settings ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Why teradata is used?
List out teradata data types?
