How does oracle realize the function of dynamically querying data from 8: 00 a.m. to 8: 00 a.m. The day before?
This article is about how oracle can dynamically query data from 8: 00 a.m. to 8: 00 a.m. the day before. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.
You need to query the data from 8: 00 a.m. to 8: 00 a.m. the day before.
Here is the query sql statement
SELECT DEPT_ID, COUNT (*) DIDFROM "MES_MACH_CALL_EVENT" WHERE CALL_TIME > = trunc (sysdate-1) + 8max 24 AND CALL_TIME