Sample SQL Query to Get Support Cases in which Last Modified Date is within 24 Hours

To get support cases in which the last modified date is within 24 hours, users can use "WHERE" to compare the date.

Below is a sample query to get the Support Cases that have been modified within 24 hours.

SELECT  *
FROM SUPPORT_INCIDENTS
WHERE LAST_MODIFICATION >= SYSDATE - 1