https://community.jmp.com/t5/Discussions/how-can-I-query-only-the-last-update-data/m-p/540132#M76079 <PRE><CODE class=" language-jsl">dt = current data table(); dt &lt;&lt; select where( :time stamp = col max(:time stamp) );</CODE></PRE> Sat, 03 Sep 2022 01:45:12 GMT txnelson 2022-09-03T01:45:12Z https://community.jmp.com/t5/Discussions/how-can-I-query-only-the-last-update-data/m-p/540118#M76077 <P>Hi,</P><P>&nbsp;</P><P>when there are multiple record in the database, how can I query only the last data (based on time stamp) ?</P> Fri, 09 Jun 2023 17:09:05 GMT https://community.jmp.com/t5/Discussions/how-can-I-query-only-the-last-update-data/m-p/540118#M76077 yanee 2023-06-09T17:09:05Z https://community.jmp.com/t5/Discussions/how-can-I-query-only-the-last-update-data/m-p/540132#M76079 <PRE><CODE class=" language-jsl">dt = current data table(); dt &lt;&lt; select where( :time stamp = col max(:time stamp) );</CODE></PRE> Sat, 03 Sep 2022 01:45:12 GMT https://community.jmp.com/t5/Discussions/how-can-I-query-only-the-last-update-data/m-p/540132#M76079 txnelson 2022-09-03T01:45:12Z