Hi, My question is " How to display 3rd highest salary
record from the internal table. The internal table has 2
fields named emno(Employee number) and salary.".
Send answer to my mail shaiksha.it@gmail.com.
Thanking you.
Answer Posted / shaiksha
Extract the content of 2nd field Using... <Select distinct
salary from ztable_emp into .... order by descending.>. Now
you can have all records in it table, exactly 3rd record
itself is highest salary record. Then basing salary extract
entire record using select statement.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are the internal tables and work area?
What is the difference between tables and structures?
What is the process to enhance the Infotype
2)In production what is the user exit?
How to add a column to a table control while using alphanumerical layout editor ?
What work you have done in HR module
Events that can be used in both the classical and interactive reports
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
Explain the Inportance of pa30? : abap hr
Can a domain, assigned to a data element be changed?
in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
Why do we use abstract class
Define abap/4 layer?
Can i know some of the Realtime tickets that anyone has been faced ?