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 / balamurugan

REPORT zscenario.
DATA itab LIKE zabc OCCURS 10 WITH HEADER LINE.
SELECT * FROM zbad5 INTO TABLE itab.
SORT itab BY sclass smarks.
LOOP AT itab.

AT NEW sclass.

WRITE: / itab."-sno1 itab-sclass itab-smarks.

ENDAT.
This display the report based upon the class.But i don't know how to retrieve 10 records from each class.

ENDLOOP.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between inner join and outer join?

1146


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

1132


8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?

2159


Explain how do you get output from idoc?

1166


What is the significance of the screen number ‘0’?

1092


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

2224


Difference between top-of-page and top-of-page during at line- selection?

2394


What do you mean by batch data communications programming?

1023


What are critical issues you have faced in your project

3412


What is meant by hide area?

1191


Advantages and disadvantages of different types of bdc's?

1082


What are pooled tables? : abap data dictionary

1198


How the transaction that are programmed by the user can be protected?

1157


Which infotype records can not be deleted ? : abap hr

1138


Explain the difference between float and packed data type?

1461