Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    12

    Thumbs up Unanswered: Ranking of marks

    Hi, I have a database which stores marks for all students in different subjects. How can I rank only a particular class in Maths without the ranking affecting the other classes? Your help will deeply be appreciated. Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Asadi View Post
    How can I rank only a particular class in Maths without the ranking affecting the other classes?
    Code:
    SELECT ...
      FROM daTable
     WHERE class = 'particular'
       AND subject = 'maths'
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •