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

in the select statement use the max keyword and select up to
3 rows .

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you use tab sets in layout sets?

1177


What actually happens in real-time recruitment? : sap abap hr

1093


Write syntax for message error (report)?

1151


What is use of transparent table in abap? How it is different from pool tables?

1427


Define the various contents of technical specifications ?

1143


What is the differences between abap and ooabap. In which situation we useooabap?

1561


Static and instance variable and method with live example. Why and when to use

1502


Differentiate between the uline and write: sy-uline statements if any?

1268


What is the tcode to create indexes?

1084


1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?

2016


In which table the material master data is stored?

1081


Final class

1607


How do you import pay scale data from non sap to sap? : sap abap hr

1230


How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?

1164


How would you set the formatting options statically and dynamically within a report?

1145