NYCPHP Meetup

[Ben Sgro]

Hello,

Thanks to all. I was doing this for the individual id selection, and it just
appeared that it wouldn't work for all id's.

I should have just tried it before asking.

Thanks again,

- Ben

Allen Shaw wrote:
> Ben Sgro wrote:
>> I have a table that includes an id (not unique and a version).
>> A unique row is identified by both the id and version. This is for 
>> MSSQL.
>> I want to select all the id's, but only return the most up to date 
>> version.
> Hi Ben,
>
> Not sure about MSSQL but I believe the following is standard sql:
>
> select id, max(version) from mytable group by id;
>
> - Allen
>