It may be simple for many of you. But I am stuggling with this.
I have a simple table like this. I want to select the records with one record per each name which has recent date. the result should be like given below.
NAME DATE
---- ----
NAME1 2008-02-12 06:32:14.380
NAME2 2004-03-14 06:35:03.420
NAME3 2002-07-20 06:23:21.463
NAME2 2001-03-01 04:33:24.356
NAME1 1999-03-14...