Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 does an exec sql statement do in abap?

1094


What do you do when the system crashes in the middle of a BDC batch session?

1126


What are system fields for secondary lists?

1014


data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.

2264


What are the events used in abap in the order of execution?

954


What is the disadvantage of a call by reference?

1048


Explain the differences between sap memory and abap memory?

924


Explain different types of locks?

1001


When was the sap abap being created?

1078


Explain the advantages/disadvantages of logical databases?

971


What is the use of table maintenance allowed?

1006


How to find Kernal badi ?

1552


where do we store all custom programs in SD module?

5612


Explain Catch Command in ABAP?

1227


What are different ABAP editors? What are the differences?

1055