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 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
- 11284 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
What is meant by a Clique?
What is the multi-insert?
What is the maximum number of dml can be coded in a multiload script?
Explain the term 'row' related to relational database management system?
What are the joins in teradata and how many types of joins are there in teradata?
What is a sparse index?
how can we analyze the locks ?
Different phases of multiload?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are types of partition primary index (ppi) in teradata?
Highlight a few of the important components of Teradata?
What is meant by a Least Cost Plan?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How does hashing happens in teradata?
Explain the term 'foreign key' related to relational database management system?
