I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it?

Hi There
Try The Following
SELECT DISTINCTROW TOP 10 Students.StudentName AS TopTenStudents, Students.StudentGrade
FROM Students


This sounds similar to something I'm trying to do...

I'm trying to write a query to get my video database to display names and addresses of people who have hired five videos or more....so far I'm displaying everyone who has hired a video - not too sure how to make it realise that I only want the ones who have hired more than five videos!!! I'm stuck :(

Any ideas are greatly appreciated

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.