List:General Discussion« Previous MessageNext Message »
From:Camilo Rostoker Date:October 7 2001 12:09am
Subject:Tricky SQL Query?
View as plain text  
Hi,
Well, I consider it tricky because I've never done it before ... but
here we go:

I have a table with game results, like winning/losing teams,
winning/losing scores, etc, and I want to sort the table based on an new
(but hidden) attribute, say points = wins*3 - losses.

Somewhat Pseudo Code:

SELECT TeamName,TeamWins,TeamLosses FROM GameResults ORDER BY {Points =
TeamsWins*3 - TeamLosses}

Thanks for the help!

Cheers,
Camilo


--
+====================================================+

Camilo Rostoker
Web Developer
Scottsdale I.T. Consulting

camilo@stripped
http://www.scottsdale.ca/

+====================================================+


Thread
Tricky SQL Query?Camilo Rostoker7 Oct
  • Re: Tricky SQL Query?Clyde Jones7 Oct