stan <stanb@panix.com> writes:
> I have a table that contains a series of rows. Each row has a project key,
> a start date, and an end date. There are multiple rows with different start
> and end dates for each project.
> I need to return something that contains, one row per project key, with the
> min(star date) and max(end date) for ALL the records for that given
> project.
Maybe I'm misunderstanding something, but isn't this just
select project_key, min(start_date), max(end_date)
from my_table
group by project_key
??
regards, tom lane
