Hi, I was looking to get distinct values from a column, but wanted to get the latest create time.
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:
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.