Re: Getting pk of the most recent row, in a group by - Mailing list pgsql-sql

On 8/13/07, Bryce Nesbitt <bryce1@obviously.com> wrote:
> In the second example, is it possible to get the primary key of the row
> with the minimum expires time?

SELECT   TYPE, MIN(expires), COUNT(*)      , (SELECT MIN(coupon_id)           FROM coupon          WHERE expires =
MIN(c.expires))AS coupon_id   FROM coupon c
 
GROUP BY TYPE;