Member Avatar for sham

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

  • 3 Contributors
  • 2 Replies
  • 170 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by iseedeadpixels
Member Avatar for wkalo

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

Rgds

Member Avatar for iseedeadpixels

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.