SELECT MAX value based on 2 groupings and ordered by date

SQLServerCentral » Latest topics

SELECT MAX value based on 2 groupings and ordered by date

Hi,

Here is an example of the data:
[code language="sql"]
ID GROUP PEOPLE DATE REQUIRED_FIELD
1    1     1     1    &n

more info...