SQL query for top ten students

[faisal khan]

Hello
I have table name Student(name,marks,....)
I want to write the query that fetch the TOP TEN Students from the Student Table on the basis of their marks
regards
Faisal
[ March 18, 2004: Message edited by: Bear Bibeault ]

[David Peterson]

You could use a SELECT statement with an ORDER BY clause and then pull off just the first ten rows using a for loop. Alternatively some databases allow you to specify the number of rows to return, as part of the query (e.g. the syntax in SQL Server is SELECT TOP 10 .... In MySQL it comes as the end of the query as ... LIMIT 10). Check out the documentation for your database.

[faisal khan]

thanks for reply
but i want sql query for this in oracle
please send me the code
regards
Faisal :roll:

[Tom Blough]

For Oracle, try:

SELECT name, marks
FROM student
WHERE ROWNUM <= 10
ORDER BY marks DESC;

Tom Blough

[faisal khan]

thanks for sending query but it do not give the results that i want..
please send me the correct query for getting Top 10 students according
their (marks)
Faisal

[Amy Phillips]

Hi Faisal,
In oracle you can use Rank and then specify how many of the records to return so in this case 10. Have a search in google and you will find some good examples of how to use it.
Amy

[shankar vembu]

Originally posted by David Peterson:
You could use a SELECT statement with an ORDER BY clause and then pull off just the first ten rows using a for loop.

I would prefer to do this, other alternatives are database dependent.
Regards.

[faisal khan]

thanks .....

[Raj Ma]

you try this..
SELECT * FROM
(SELECT STUDENT.*, DENSE_RANK() OVER(ORDER BY MARKS DESC) AS RK
FROM STUDENT)
WHERE RK <=5