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

What is the differrences between structure and table in data dictionary in abap? : abap hr

720


What is projection view?

540


What kind of deliverables you have on a day to day basis?

967


How to eliminate duplicate entries in internal tables?

681


What is pnp-sw-found ? : abap hr

871






Differentiate between report and dialog program

600


What is bdc programming? : abap bdc

579


how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

3416


what is abstract classes

877


What are pooled tables? : abap data dictionary

665


How can you access the function code from menu painter?

635


Proxy Programming with ABAP - How to develop the Proxy identification through programming

1885


What is a matchcode?

597


Final class

1019


How to Solve a Particular Ticket in Realtime ?

1751