|
Posted by Jerry Spivey on 09/27/05 03:56
Use the MAX function.
HTH
Jerry
"JohnnyRuin" <schafer.dave@gmail.com> wrote in message
news:1127754721.101989.205780@f14g2000cwb.googlegroups.com...
>
> Hi,
>
> My table has int Field1 and DateTime dtModificationTime. I maintain a
> history of changes to the table by inserting a new record with a new
> dtModificationTime. I need to be able to find the last inserted
> record. It's easy to do Select * from table where field1=x ORDER BY
> dtModificationTime. That works, but it hits all the records that
> match the field. I need to come back with an exact hit. Can someone
> point me in the right direction?
>
> Thanks.
>
Navigation:
[Reply to this message]
|