Posted by JohnnyRuin on 09/26/05 20:12

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.

• Next in forum: Re: Finding the most recient datetime
• Prev in forum: Re: ordering an int column
• Thread view: Finding the most recient datetime

[Reply to this message]