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
why use references rather than pointers in the public api, particularly for arguments which are modified?
what are the uses of fact table and dimension table in banking project?
How do you define Teradata?
What is spool space? Why do you get spool space errors?
Which is more efficient group by or distinct to find duplicates?
What are the steps involved after the disk manager passes the request?
How you will check the version of teradata?
What are the enhanced features in teradata v2r5 and v2r6?
List out teradata data types?
Explain amp in teradata?
In BTEQ, how are the session-mode parameters being set?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are different table types used in teradata?
What is bteq utility in teradata?