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


Please Help Members By Posting Answers For Below Questions

What is sap abap data dictionary?

625


I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.

1344


What is the transaction for recording bdc ? : abap bdc

596


there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?

1755


How do you validate the selection criteria of a report? And how do you display initial

582






What is the table & field to identify the no of items (bottles) stored in one case?

1971


How to create user interfaces for lists?

605


Which type of tables used this buffer?

589


How is collect statement different from append?

586


How to do find it?

553


How do you write transaction programs in sap?

574


What are the different modules of sap? : sap abap hr

548


The max number of calling modes stacked at one time is?

580


What is PS structure

1622


what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

1988