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 to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul

2877


Explain how is batch input process different from processing on line?

566


How many lists can a program can produce?

604


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

975


How would you set the formatting options statically and dynamically within a report?

666






How does the interface between the dynpro and the abap/4 modules take place?

558


Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

634


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

589


What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?

2248


How to maintain lists?

623


What is open sql vs native sql ?

1868


Explain what is step-loop? Explain all the steps?

719


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

609


What is the bapi?

609


Cds views

7704