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
- 11406 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
Explain the new features of teradata?
List out all forms of LOCKS that are available in Teradata.
What is a dimension table?
Explain the term 'primary key' related to relational database management system?
What are the various etl tools in the market?
Difference between inner join and outer join?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is stored procedure in teradata?
what are the day to day activities of teradata DBA ?
What are the available primary index types?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How do you define Teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the syntax for case when statement?
