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...

A database table contains 3
fields(Student_no,Section,Total_marks).I want retrieve top 10
students from each section.Note:(Section contains data like
A,B,C.Each section contains more than 10 students).

Answer Posted / sivaramakrishna

according to our requirment
get allthe records using select * from st_db into stu_itab1.
1.first sort the stu_itab1 by marks field.
now use the select single section from st_db into stu_itab2.
now we have to use select for all entries as below.
select section marks from stu_itab1 into table stu_itab3
for all entries in stu_itab2 upto 10 rows.

it may be not exact . but do try in this way

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is exception class and test class. How to use it?

1434


what is bapi,badi,bdc,ale idocs?

2353


Can we use transfer dataset to transfer data in internal table ?

2151


What is the use of table control in bdc is it same in module pool table control? : abap bdc

1283


How do you use structures in the abap programs?

1155


Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?

1578


How can we decide weather we can enhance the standard infotype or not ? : abap hr

1143


What is the diff between database view and maintenance view?

1105


Write the bdc table structure? : abap bdc

1090


Can you set up background processing using call transaction?

1063


Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?

1162


Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr

1151


Explain the Inportance of pa40? : abap hr

1108


What are the two ways for restricting the value range for a domain? : abap data dictionary

1030


What is value table? : abap data dictionary

1163