查询表中开始日期与结束日期
select startTime ,endTime from
(
select create_time as startTime, 1 as 'id' from
(
select DISTINCT(create_time)
from wifi_third_history_flow_information
ORDER BY UNIX_TIMESTAMP(create_time) DESC limit 1
) as temp
) A
join
(
select create_time as endTime, 1 as 'id' from
(
select DISTINCT(create_time)
from wifi_third_history_flow_information
ORDER BY UNIX_TIMESTAMP(create_time) ASC limit 1
) as temp
) B
on A.id = B.id;
#方式二
select create_time from (
select create_time from
(
select DISTINCT(create_time)
from wifi_third_history_flow_information
ORDER BY UNIX_TIMESTAMP(create_time) DESC limit 24
) as temp limit 1 )
as a
UNION
select create_time from (
select create_time from
(
select DISTINCT(create_time)
from wifi_third_history_flow_information
ORDER BY UNIX_TIMESTAMP(create_time) ASC limit 24
) as temp limit 1 )
as b