DataTable shortcode for the last record (LIMIT 1)

Hello,

I would like to use DataTable to get a single record from MySql Database, e.g.

SELECT *
FROM MyTable
ORDER BY datetime DESC
LIMIT 1;

I need to display this value on a page as a shortcode. If there is another way…

Any help would be useful, thank you!