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

Explain what are the problems in processing batch input sessions?

1079


What are the prerequisites for creating foreign key relationship?

1154


What is the last entry in all bdc tables? : abap bdc

1111


Is a logical database a requirement/must to write an abap/4 query?

1082


What are the disadvantages of different types of bdc's?

1115


What are conversion & interface programs in sap?

1132


What is the difference between Classic badi and Kernal badi ?

2532


What is tcode se16. For what is it used. Explain briefly?

1059


What are the steps to be followed to set lockobjects? : sap abap data dictionary

1106


What is a report?

1257


Explain what are the events used for logical database?

975


What is dialog module?

1069


What are the different software packets available in the market? : sap abap hr

1092


what is difference between (internal table types)standard table and sorted table in sap abap....

2408


Explain the differences between interactive and drill down reports?

1020