CodingForums.com - View Single Post

Old Pedant · 11-27-2012, 06:55 PM

Well, since you are no longer using my answer, at all, I'm not sure what to tell you.

But of course you are getting the lowest overall price. That's what

Code:

SELECT min(price) as min FROM expedia

is *SUPPOSED* to do.

11-27-2012, 06:55 PM	PM User \| #24
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,178 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	Well, since you are no longer using my answer, at all, I'm not sure what to tell you. But of course you are getting the lowest overall price. That's what Code: SELECT min(price) as min FROM expedia is SUPPOSED to do. __________________ 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.