I have DATETIME stamp in columnB.
I want all the latest rows for a particular date.
ColumnA ColumnB
------------------
NJ 2003-06-30 10:22:02.700
CO 2003-08-04 09:49:13.247
NJ 2003-08-04 09:51:47.667
CO 2003-08-26 11:01:58.743
FL 2004-10-09 11:48:13.610
FL 2004-10-09 11:50:13.610
For e.g from the above data i want output as -
ColumnA ColumnB
------------------
NJ 2003-06-30 10:22:02.700
NJ 2003-08-04 09:51:47.667
CO 2003-08-26 11:01:58.743
FL 2004-10-09 11:50:13.610
Pls. help. Thanks!
I want all the latest rows for a particular date.
ColumnA ColumnB
------------------
NJ 2003-06-30 10:22:02.700
CO 2003-08-04 09:49:13.247
NJ 2003-08-04 09:51:47.667
CO 2003-08-26 11:01:58.743
FL 2004-10-09 11:48:13.610
FL 2004-10-09 11:50:13.610
For e.g from the above data i want output as -
ColumnA ColumnB
------------------
NJ 2003-06-30 10:22:02.700
NJ 2003-08-04 09:51:47.667
CO 2003-08-26 11:01:58.743
FL 2004-10-09 11:50:13.610
Pls. help. Thanks!