Re: SELECT DISTINCT ... ORDER BY problem

On Tue, Dec 9, 2008 at 9:02 AM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> or even, when you change bar to proper type - that is, timestamp
>
> SELECT distinct foo,  min(bar) as minbar, max(bar) as maxbar FROM
> table WHERE bar < '2008-12-07
>  16:32:46' AND tbl_id=153 ORDER BY bar LIMIT 1;

but than (after sec of thinking), you could just do

SELECT foo, min(bar) AS minbar, max(bar) AS maxbar FROM table
WHERE ..blabla.. GROUP BY foo ORDER BY maxbar LIMIT 1;





--
GJ