Hi, I was looking to get distinct values from a column, but wanted to get the latest create time.

Code:
ID   CREATETIME   EVENT   UPDATEDBY
1    2013-1-1     1       Bob
2    2013-1-3     1       John
3    2013-1-6     3       Dave
4    2013-1-8     2       Jim
5    2013-1-15    3       Jess
I would be looking unique event numbers, but with the createtime and its updatedby field. I don't think the distinct will be any use, because when attempting to do that it comes back with everything (as all rows are distinct).

Instead, rather have this:
Code:
ID   CREATETIME   EVENT   UPDATEDBY
2    2013-1-3     1       John
4    2013-1-8     2       Jim
5    2013-1-15    3       Jess
Any ideas greatly appreciated.