Здравствуйте помогите объединить два запроса? Код (Text): SELECT MAX(ID), min(id) FROM `gpsdata` WHERE `DEVICE_ID`= 354007390 AND `timestamp` BETWEEN '2021-01-01' AND '2021-01-31' выбираем два ИД и вставляем Код (Text): SELECT id, `TIMESTAMP`, `TRACK` FROM `gpsdata` WHERE ID IN(Сюда) Пробовал так: Код (Text): SELECT id, `TIMESTAMP`, `TRACK` FROM `gpsdata` WHERE ID IN (EXISTS (SELECT MAX(ID), min(id) FROM `gpsdata` WHERE `DEVICE_ID`= 354007390 AND `timestamp` BETWEEN '2021-01-01' AND '2021-01-31')) не получается..... --- Добавлено --- Так тоже не получается: Код (Text): SELECT id, `TIMESTAMP`, `TRACK` FROM `gpsdata` WHERE ID IN ( EXISTS(SELECT MAX(ID) FROM `gpsdata` WHERE `DEVICE_ID`= 354007390 AND `timestamp` BETWEEN '2021-01-01' AND '2021-01-31') , EXISTS(SELECT MIN(ID) FROM `gpsdata` WHERE `DEVICE_ID`= 354007390 AND `timestamp` BETWEEN '2021-01-01' AND '2021-01-31') ) и обрабатывается оч долго
Код (SQL): SELECT b.id, b.`TIMESTAMP`, b.`TRACK` FROM (SELECT MAX(id) AS max_id, MIN(id) AS min_id FROM gpsdata) AS a JOIN gpsdata AS b ON b.id IN(a.min_id, a.max_id)