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...

There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.

Answer Posted / sutirtha

Select Order by Rank and up to 3 rows 

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which commands are used for interactive reports?

1313


What is off cycle payroll run

2518


What are the two different ways of building a match code object?

1085


What are the update types possible? : abap data dictionary

1066


Which objects are independent transport objects?

1340


What is the difference between select statement and provide statement ? : abap hr

1121


What is asynchronous and synchronous update?

1097


What is the differences between structure and table in data dictionary in abap?

1141


Explain lsmw?

1135


What are the types of data types in the sap abap?

1082


How can we upload a text file having delimiters in to legacy system?

1125


How is conversion of data types done between abap/4 & external level?

1085


in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.

2322


What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

1275


i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?

2288