NYCPHP Meetup

[Allen Shaw]

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

-- 
Allen Shaw
slidePresenter (http://slides.sourceforge.net)