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
What is a development class? : abap data dictionary
What are the update types possible?
Explain the systems fields used for interactive lists and lists?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
What are matchcodes?
how can we enable hyperlink in screen painter?
What is help view?
How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul
In select-options, how to get the default values as current month first date and last date by default?
What is the use of enqueue function module? : sap abap data dictionary
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
What is the difference between function group and function module?
Which objects are independent transport objects?
What is asap methodology? : sap abap hr
What are the different types of operators in the sap abap?