Home » SQL & PL/SQL » SQL & PL/SQL » to display top ten and bottom ten student as per their grade (oracle 8i and dev 60)
to display top ten and bottom ten student as per their grade [message #312199] Tue, 08 April 2008 03:25 Go to next message
orarep
Messages: 56
Registered: September 2007
Member
hello every one


i have a tbale conatining 400 records of student marks .i need to display the first top ten student name and roll number and then the bottom ten students as per thier final total marks

plzz suggest sql query to do it

thank you



regards


orarep
Re: to display top ten and bottom ten student as per their grade [message #312200 is a reply to message #312199] Tue, 08 April 2008 03:29 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
This is a very commonly asked requirement. Search the forum for 'Top N' (and variants of)
Previous Topic: Minute Differences
Next Topic: A simple function
Goto Forum:
  


Current Time: Sat Dec 10 22:51:33 CST 2016

Total time taken to generate the page: 0.07020 seconds