How to reterive the newly updated record? [message #355909] |
Tue, 28 October 2008 08:12  |
aviva4500
Messages: 122 Registered: July 2008 Location: bangalore
|
Senior Member |
|
|
Dear All,
I am in need of a kind suggestion in the datepart.I have a table name called Test,which has 3 columns.The data is shown below:
----------------------------------------------------------------
Name country datecreated datetimelastmodified
XXX yyy 9/15/2008 1:54:23 PM 9/15/2008 1:55:12 PM
XXX zzz 9/15/2008 1:54:23 PM 10/23/2008 3:52:16PM
----------------------------------------------------------------
If i issue the distinct query on the above data i get both the records obviously.But i need only the record which is recently modified in my output.That is the second one which is modified on 10/23/2008 3:52:16PM.
Thanks & Regards
Hammer.
|
|
|
|
|