Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Apr 2008
    Posts
    46
    Thanks
    1
    Thanked 0 Times in 0 Posts

    select best price between MYSQL columns and rows

    Hi all! and happy new year, off course! ))

    I need to get the best price between columns and also rows.

    i got a table like this
    inputs - price1 - price02 - price3
    v1 - 90 - 92 - 110
    v2 - 85 - 95 - 100

    I'm getting the minimal price of each input but can't get the absolute minimal price.

    Thanks in advance.

  • #2
    New Coder
    Join Date
    Apr 2008
    Posts
    46
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by niko-cola View Post
    Hi all! and happy new year, off course! ))

    I need to get the best price between columns and also rows.

    i got a table like this
    inputs - price1 - price02 - price3
    v1 - 90 - 92 - 110
    v2 - 85 - 95 - 100

    I'm getting the minimal price of each input but can't get the absolute minimal price.

    Thanks in advance.
    nobody knows how to make it? or would you need me to explain better my problem?

  • #3
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    Try using the LEAST() function, in conjunction with MIN().

    http://dev.mysql.com/doc/refman/5.0/...function_least


  •  

    Posting Permissions

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