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
1 20 76 50
2 30 94 40
3 40 90 30
4 70 20 30
5 23 40 40
6 85 30 55
7 84 20 65
8 10 93 40
9 57 30 30
10 38 83 40
11 35 39 90
12 83 89 50
Now the Question is i want get the max sales of 12 products
from the months.hint:for eg I WANT GET 89 for product12...
Can any one help me
- 8 Answers
- 11222 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / rkraju
HI,
>>THE QUERY IS
>>SELECT CASE WHEN JAN>FEB AND JAN>MAR THEN JAN ELSE (CASE
WHEN FEB>JAN AND FEB>M
R THEN FEB ELSE MAR END) END FROM SALES;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the uses of fact table and dimension table in banking project?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
if collect stats but it show low confidence why?
What is the difference between union and union all in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the steps to create a data model?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
List out teradata data types?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
any one answer me how they can analyzing the project using data ware housing?
Describe primary index in teradata?
What is meant by a Channel Driver?
What are the uses of bynets in multi-node systems?
How you will check the version of teradata?
