Hello All, 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. So, for a table id | version ------------- 1 | 0 1 | 1 2 | 0 2 | 1 2 | 2 The query should return id | version ------------- 1 | 1 2 | 2 Any help much appreciated. - Ben _______________________________________________ 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
