won/loss average

longway

Member
Joined
Mar 9, 2005
Messages
6
Programming Experience
Beginner
I sure hope someone can help me. I am currently the world's most confused person. I am trying to run this query:

SELECT * FROM nfcnorth
Order By Won / (Won + Loss)DESC

Here are the results:

TeamID TeamName Won Loss

CHC Chicago 2 3
DET Detroit 1 4
GBP GreenBay 3 3
MIN Minnesota 3 2

This isn't even close! How can this be?? I am totally baffled. HELP!
 

kulrom

Well-known member
Joined
May 10, 2005
Messages
2,854
Location
Republic of Macedonia
Programming Experience
10+
Hi Longway
Just a friendly reminder to try to avoid double posting.
Thanks for understanding
palec.gif


thread continues here:
http://www.vbdotnetforums.com/showthread.php?t=5123

I suppose your problem should be resolved so far. I tried and it works good for me.
VB.NET:
[color=blue]select[/color] * [color=blue]from[/color] nfcnorth [color=blue]order by[/color] result [color=darkgreen]'where result is calculated percentage and it should be enough[/color]

Regards ;)
 
Top Bottom