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

Select Order by Rank and up to 3 rows

Is This Answer Correct ?    9 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we determine a vendor is Bloc/Unblock from the table LFA1?

1660


What are the data types of the external layer?

584


Differentiate between report and dialog program

600


Explain sap abap 3-tier architecture?

737


Explain the table, which contain the details of all the name of the programs and forms?

526






What are the Various Types of internal tables?

743


How to create a link between modified form and modified print program?

587


Fallback class

1744


How to upload data using catt ? : abap hr

616


Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr

642


What does the extract statement do in extract datasets?

650


visibility section for class level and attributes level

817


Name the abap/4 modularization techniques?

650


What are spa/gpa parameters (sap memory)?

725


What is abap work bench?

731