> SELECT *
> FROM external_api
> WHERE id = :my_id
> AND sync_token = (SELECT max(sync_token) FROM ext_api WHERE id = :my_id)
Does this have an advantage over SELECT * FROM external_api
WHERE id = :my_id
ORDER BY sync_token DESC
LIMIT 1
? Assuming the index is on (id, sync_token).