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

Difference between transparent tables and pooled tables? : abap hr

557


Explain the different types of mode (run code) in call transaction method?

567


What is the modification assistant?

582


How to upload more than 2GB file from External Source to SAP?

858


How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?

1678






In sap script how to print bar code in vertical manner

2632


How many types of data classes are there in sap?

587


suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?

1859


How do you Export a session ?

1452


How to find the return code of a statement in abap programs?

609


Application Category?

920


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

592


What is a help view? : abap data dictionary

673


How can you find the field/data underlying a transaction?

605


What is the t-code for transaction recorder? : abap bdc

599