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
- 11127 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
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is difference between user and database in teradata?
What is smp and mpp platforms?
Highlight a few of the important components of Teradata?
What are the functions of a teradata dba?
What do you mean by parsing?
What are the joins in teradata and how many types of joins are there in teradata?
How you will check the version of teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is the use of stored procedures in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is a three-tier data warehouse?
Highlight the limitations of TPUMP Utility.
How do you determine the number of sessions?
How to view every column and the columns contained in indexes in teradata?
