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 are your ways to performance optimization?

1367


What is roles and responsibilities of sap hr consultants? : sap abap hr

1104


What are the events we use in dialog programming and explain them?

1006


What is macro? : abap hr

1095


What is PS structure

2158


Difference between select option and ranges ?

1088


What is a table pool? : abap data dictionary

1060


Explain the use of insert and append statement in sap abap?

1070


What was the requirement of IDoc in your project? How it was working?

2033


Where do you use help views?

961


Sal abap on hana interview

1327


What is the use of at new statement ?

1774


what is bapi,badi,bdc,ale idocs?

2249


What is the difference b/t Session method and call transaction method ??

6173


Why bapi need then bdc ? : abap bdc

1091