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

There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.

Answer Posted / gaurav walia

first sort the rank field by descending.....den select rank up to 3 rows...

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?

2810


What is an interactive report?

1055


SAP query how to use end users?

2157


​​Can multiple abap systems connect to abap database?

1078


What is a variable in the sap abap?

1008


dynamic programming in sap abap

1431


How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.

2335


Which transaction code can I use to analyze the performance of abap program?

998


Can you delete data element, which is being used by table fields?

1308


Explain what are extracts?

1056


If I want to execute a program only in background not in foreground is there any option for this? : abap bdc

978


Why grouping of fields is required? What is the max no of modification groups for each field?

983


Select query optimisation

1336


What is smart forms? : abap hr

1055


how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

3894