I have a table Project. It has the following column:
Project ID, projectName, UpdateTime
The data in the table is as follows:
1, abc, 12-2-2009 01:10:00
1, abc, 12-2-2009 04:18:00
2, xyz, 17-7-2009 08:45:00
2, xyz, 17-7-2009 12:21:00
i want the result set to display the latest update...