Re: help formualting a query

2019-09-08 Thread Tom Lane
stan 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)

help formualting a query

2019-09-08 Thread stan
I am having a hard time figuring out to do this, the SQL way. Doing in a procedural way with a foreach would be deasy, but I suspect that a properly formulated SQL query can achieve this. I have a table that contains a series of rows. Each row has a project key, a start date, and an end date. Th