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 cts and what do you know about it? : abap hr

913


Did you create primary index?

736


What is an abap instance?

806


Reports: Event functionality.

1067


Folder types in smatforms? 2)What is Command line?

2109






What are types of select statements?

773


What is append structure?

727


the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....

1758


What are the advantages/ dis-advantages of logical databases?

732


what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march

1884


Work most on which module: name a few tables?

752


why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.

1934


What are the disadvantages of using explicit enhancement?

1662


What is table attribute? : abap data dictionary

773


What is a development class? : abap data dictionary

909