CodingForums.com - View Single Post

Old Pedant · 11-26-2012, 11:54 PM

It *looks* to me like you could do something like this:

Code:

SELECT L.lowest, E.*
FROM expedia AS E,
     ( SELECT tag, MIN(price) AS lowest
       FROM expedia
       GROUP BY tag ) AS L
WHERE E.tag = L.tag
ORDER BY E.tag, E.price

to get similar results from your data.

11-26-2012, 11:54 PM	PM User \| #14
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,193 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	It looks to me like you could do something like this: Code: SELECT L.lowest, E.* FROM expedia AS E, ( SELECT tag, MIN(price) AS lowest FROM expedia GROUP BY tag ) AS L WHERE E.tag = L.tag ORDER BY E.tag, E.price to get similar results from your data. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.