пробую подзапросом
select min(m.datetime), max(m.datetime)
from messagelog m
where user_id=3 and
CAST(FLOOR(CAST(m.datetime AS FLOAT)) AS DATETIME) IN
(select distinct CAST(FLOOR(CAST(m1.datetime AS FLOAT)) AS DATETIME)
from messagelog m1)
group by m.datetime
результата нет
|