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 your ways to performance optimization?
What is roles and responsibilities of sap hr consultants? : sap abap hr
What are the events we use in dialog programming and explain them?
What is macro? : abap hr
What is PS structure
Difference between select option and ranges ?
What is a table pool? : abap data dictionary
Explain the use of insert and append statement in sap abap?
What was the requirement of IDoc in your project? How it was working?
Where do you use help views?
Sal abap on hana interview
What is the use of at new statement ?
what is bapi,badi,bdc,ale idocs?
What is the difference b/t Session method and call transaction method ??
Why bapi need then bdc ? : abap bdc