cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
yanee
Level III

how can I query only the last update data ?

Hi,

 

when there are multiple record in the database, how can I query only the last data (based on time stamp) ?

1 REPLY 1
txnelson
Super User

Re: how can I query only the last update data ?

dt = current data table();
dt << select where( :time stamp = col max(:time stamp) );
Jim