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 is the difference between scrolling a table horizontally and vertically?
What is the use of lock objects?
What is the use of abap data dictionary? : abap data dictionary
HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?
What are the events used in abap in the order of execution?
Difference between function group and function module?
What is an “on input filed” statements?
What is a help view? : abap data dictionary
How to find the return code of an stmt in abap programs?
Is it possible to run host command from SAP environment? How do you run?
Why bapi need then bdc ? : abap bdc
Will 50,000 records be uploaded directly into APP's Server?
What are the parameter types for a method?
What is a persistent class?
Explain the Inportance of pa40? : abap hr