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
Explain what are the problems in processing batch input sessions?
What are the prerequisites for creating foreign key relationship?
What is the last entry in all bdc tables? : abap bdc
Is a logical database a requirement/must to write an abap/4 query?
What are the disadvantages of different types of bdc's?
What are conversion & interface programs in sap?
What is the difference between Classic badi and Kernal badi ?
What is tcode se16. For what is it used. Explain briefly?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
What is a report?
Explain what are the events used for logical database?
What is dialog module?
What are the different software packets available in the market? : sap abap hr
what is difference between (internal table types)standard table and sorted table in sap abap....
Explain the differences between interactive and drill down reports?