Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    28

    Unanswered: Order by+DESC and negative number

    Hello,

    I have a little problem that I would be glad if someone could help me to solve.

    I have a table with a number of players, in that table I have all players scores and game difference.

    If I do a:" SELECT* FROM player ORDER BY points DESC, gamediff DESC"
    I get:
    name points goaldiff
    playerA 10 15
    PlayerB 8 10
    PlayerC 6 -5
    PlayerD 6 -4

    This is wrong in ordinary mathematic because "-5" is less than "-4"
    Can I do anything to overcome this problem?

    Thanks in advance!

    // D_S

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    probably your goaldiff column is a character column instead of an int column.

Posting Permissions

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