Shulou(Shulou.com)05/31 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.