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
Static and instance variable and method with live example. Why and when to use
Define external layer? : abap data dictionary
Explain the Types of Select statements?
How many types of tables exists and what are they in data dictionary?
What are the prerequisites for creating foreign key relationship?
what precautions or prerequisites do you follow to update a record into database table and how
hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks
What are the different types of mode (run code) in call transaction method?
What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr
Can we use on change of between select and endselect?
How do you find if a logical database exists for your program requrements?
What are the requirements a dialog program must fulfill?
Is main window mandatory in smartforms?
How memory management happens for internal tables and work areas in abap?
What is the use of a pretty printer?