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)
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
