check for the lastest data in a database

[babeo]

Hello,

could some one let me know how to check for the latest data/row in a database. I want to know when or what date a data just inserted into a database.
Thanks

 

[grega]

Difficult without more info, but in general

select row
from table
where column = (select max column from table)

Greg.

 

[babeo]

Thanks Greg,

Could you rewrite the code in true style example please? (I mean similar to: select NAME from CustomerTab where NAME = 'Smith' ) . I still don't get what you mean. Thanks.

By the way, here is what I want:
I have a Perl code, and this code will auto log in a server and download the latest picked data in its database and inserted into another table, however, I want to check if :
- the code is working properly,
- and if the data is transferred from the other server to the desired table or not.

I know the code still works properly until we change the physical server !

Thanks