oracle查询任意七天的数据和最近一天的数据

1任意7天的数据

select * from JK_LOGANALYIZE_USERUSAGE where trunc(time) >= trunc((select max(time) from JK_LOGANALYIZE_USERUSAGE),'d')
and trunc(time) <= next_day(trunc((select max(time) from JK_LOGANALYIZE_USERUSAGE),'d'),7)

2.最近一天的数据

select * from JK_SERVERRUNNINGDATA where time in (select max(time) from JK_SERVERRUNNINGDATA)