Re: [SQL] Finding the "most recent" rows

Chris Bitmead  writes:
>>>> select title, summary, time from story t where time = (select
>>>> max(s.time) from story s GROUP BY s.title);

> Why doesn't replacing "=" with "IN" produce a result? It wouldn't be the
> desired result, but I thought this was legal.

I thought so too (on both counts).  Are you saying it doesn't work?
What happens?  Which version are you using?
		regards, tom lane