Latest position of a specific device
SQL query for TraxGo
Get the latest position of a specific device based on its ID.
SELECT * FROM Latest_Positions WHERE device_id = ‘specific_device_id’ ORDER BY timestamp DESC LIMIT 1;
TraxGo data model
Devices
Latest Positions
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed