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 / vinay

in the select statement use the max keyword and select up to
3 rows .

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is tcode se16. For what is it used. Explain briefly?

1008


How to write a code in tab control? : abap bdc

1106


What are the two ways of producing a list within a transaction?

990


What is pass by value and what is pass by reference? Which is better?

1344


How do you write manual bdc session method? : abap bdc

1061


What will you code in start-of-selection & end-of-selection ?

1036


What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary

1036


How to creat transactions? : abap data dictionary

1072


any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.

2351


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary

1148


What are the difference between pool tables and transparent tables?

1095


THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM

16359


what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

2381


What is exception class and test class. How to use it?

1337


What are the different types of the sap abap data dictionary objects?

996