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 the internal tables and work area?

1037


What is the difference between tables and structures?

1179


What is the process to enhance the Infotype

3455


2)In production what is the user exit?

2026


How to add a column to a table control while using alphanumerical layout editor ?

2530


What work you have done in HR module

1422


Events that can be used in both the classical and interactive reports

1657


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

1144


Explain the Inportance of pa30? : abap hr

1420


Can a domain, assigned to a data element be changed?

1129


in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.

2317


It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization

1321


Why do we use abstract class

1542


Define abap/4 layer?

1463


Can i know some of the Realtime tickets that anyone has been faced ?

2218