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.
Answers were Sorted based on User's Feedback
Answer / vinay
in the select statement use the max keyword and select up to
3 rows .
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
Is This Answer Correct ? | 0 Yes | 6 No |
What is the Difference Between basic list and interactive list?
Differentiate between static and dynamic step loops?
What is SQL Trace, how would you carried out performance analysis of ABAP code using SQL Trace? Give the steps?
What is the use of 'for all entries'?
How to debug sapscripts ?
what is OSS?please answer if anybody knows
what is the functionality of Runtime Analysis?
How do you do effort estimation? Based on which parameters?
How do you run the scripts?
what is the difference between session ,call Transaction?
three jobs are there if one fails wat happens?
What are the problems in processing batch input session?