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).
- 7 Answers
- 10380 Views
- Enteg Technologies, I also Faced
- E-Mail Answers
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
Specify the types of data dictionary objects.
What is the difference between ABAP and HR ABAP
What is a database view? : abap data dictionary
Explain what is a foreign key relationship? Explain this with the help of an example.
WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
What are smart forms?
What is open sql?
Explain what is sap script? What is the purpose of sap script?
What is a projection view? : abap data dictionary
What are the major steps will you use for tuning?
What are the different buffering methods?
What is a type group?
What are the different types of luws?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
