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
_______________________________________________
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
