SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT location_id FROM device_location WHERE (lat, long) IN ( SELECT lat, long FROM device_location WHERE speed = 0.0 GROUP BY lat, long HAVING COUNT(*) > 1 );
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear