MSSQL SELECT LIMIT 1 syntax

MSSQL
SELECT top 1 latitude, longitude FROM gps ORDER BY time DESC

MYSQL
SELECT latitude, longitude FROM gps ORDER BY time DESC LIMIT 1

沒有留言:

發佈留言