[thelist] SQL Query to count votes and order by highest
Chris Byrd
chris.byrd at openhosting.co.uk
Sat Dec 2 13:01:27 CST 2006
Hi All
I've got in a bit of a muddle with an SQL query
I'm part way through creating an online voting system for various school
'awards' and I need a query to count the number of votes for a specific
'award' and list the results in descending order
Each time there's a vote, a row is created in a 'vote' table
Amongst other fields in the 'vote' table are 'vote_to_student_id' and
'vote_award_id'
Basically, I need to be able to run a query for each 'award_id' that
will return (in descending order) the number of votes and each
corresponding vote_to_student_id
Hopefully this makes sense
I've got access to all the features of MS SQL Server 2000
Can anyone help me out? I've been at this for hours and just keep going
round in circles. Plus, I think it's a little over my head! I'll be
eternally grateful
Thanks in advance!
Chris
More information about the thelist
mailing list