Thread: max value

  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Stuttgart, Germany
    Rep Power

    I have a problem with the maximum value. I have a column with the values 8, 10, 20 and 50.

    With the SQL statement
    select (max) columnname from tablename

    I get the result that 8 is the maximum value.

    Does anyone know a solution for this problem

    Thank you
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    Sounds to me like you have the column set up as some sort of text type rather than numeric.

Similar Threads

  1. Explaining Arrays?
    By Obscurity in forum C Programming
    Replies: 2
    Last Post: December 6th, 2003, 02:46 AM
  2. Selecting MAX values
    By bajanagent in forum PHP Development
    Replies: 14
    Last Post: May 4th, 2003, 10:55 PM
  3. Query help using MAX()
    By corrierich in forum MySQL Help
    Replies: 2
    Last Post: November 13th, 2002, 02:04 AM
  4. max user connections
    By shehryarshafiq in forum MySQL Help
    Replies: 1
    Last Post: August 12th, 2002, 06:44 AM
  5. How do I select min and max with a limit
    By Pokeboy in forum MySQL Help
    Replies: 1
    Last Post: October 21st, 2001, 05:48 PM

IMN logo majestic logo threadwatch logo seochat tools logo