SELECT MIN
-
Hello, Is there a way to select a row from a table based on a minimum? Or what is the correct syntax? This query returns two rows when I only need a row with the min column... :( select min(col1ID), col2ID, col3 from tbl where col2ID = 'xxxx' group by col2ID, col3 Thanks, jay
-
Hello, Is there a way to select a row from a table based on a minimum? Or what is the correct syntax? This query returns two rows when I only need a row with the min column... :( select min(col1ID), col2ID, col3 from tbl where col2ID = 'xxxx' group by col2ID, col3 Thanks, jay
Jaydeanster wrote: This query returns two rows when I only need a row with the min column... select min(col1ID), col2ID, col3 from tbl where col2ID = 'xxxx' group by col2ID, col3 Your GROUP BY clause causes more than one row to be returned. I am guessing that you want the row with the MIN(col1ID) with the other columns too. So, assuming that each col1ID value is unique then the following should work:
SELECT m.col1ID, t.col2ID, t.col3
FROM tbl AS t
INNER JOIN (SELECT MIN(col1ID) as col1ID
FROM tbl
WHERE col2ID = 'xxxx') AS m ON m.col1ID = t.col1ID
WHERE col2ID = 'xxxx'Does this help?
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More