Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 12552 Views
- Altimetrik, I also Faced
- E-Mail Answers
Answer Posted / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How to upload more than 2GB file from External Source to SAP?
How can you access the function code from menu painter?
How to determine the attributes of an internal table?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.
Can you create a table with fields not referring to data elements? : abap data dictionary
In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?
Can you assign a matchcode object to a parameter? If so how?
How do you find number of records present in internal table?
What are the different methods of bdc? : abap bdc
Can a domain, assigned to a data element be changed? : abap data dictionary
What is the difference between collect and append statements?
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
Explain the properties of selection screen?
Explain about drill down report?
