Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / rkraju

i hope in that above query satisfy ur requirement.for that
question can anyone find new query post me
ravikiran.mca.vadali@gmail.com

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention a few of the ETL tools that come under Teradata.

1134


When tpump is used instead of multiload?

1146


List out some of the primary characteristics of teradata.

1062


What are the advantages of teradata?

1060


How would you load a very large file in teradata in general? What utility would you use for it? Why?

1145


What is the command in bteq to check for session settings ?

1234


Why managing the data is important?

1059


What is teradata and why it is used?

1183


Describe primary index in teradata?

1053


Explain the term 'row' related to relational database management system?

1001


Where is teradata rdbms used?

1139


How to run a query in teradata?

1147


What do you mean by teradata intellicloud?

1077


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1827


How will you solve the problem that occurs during update?

1107