Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on top three students within the SQL forums, part of the Databases category; I had tried to get sql commands for print students name who had got top three totals .But still i am not get exact command.so try to send the correct ...
|
|||||||
|
|||
|
top three students
I had tried to get sql commands for print students name who had got top three totals .But still i am not get exact command.so try to send the correct sql command to get three toppers in the student table
|
| Sponsored Links |
|
|||
|
Re: top three students
Quote:
In Oracle , You can try this query. SELECT Student_Name, Student_Total FROM Student_Table WHERE ROWNUM <= 3 Order by Student_total Desc |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| seminar topics for mech engg students | chandru20 | Mechanical Engineering | 0 | 10-22-2008 12:41 PM |
| Industrial Training for B Tech students | nitinkumar111 | Career Advice | 0 | 02-11-2008 05:55 AM |
| 100 doors n 100 students problem | karanampramod | Brainteasers | 5 | 02-08-2008 07:04 AM |
| howmany students are there in a department ? | psuresh1982 | Brainteasers | 3 | 01-03-2007 04:42 AM |
| Free Books for Engineering Students - Chennai | Lokesh M | Geeks Lounge | 0 | 12-31-2006 06:35 AM |