Let us assume that there is a table:
1
MESSAGE_ARCHIVE
In this table there are two columns:
1
2
WHENRECEIVED (Date)
TOPIC (VARCHAR(20))
- SQL to count the number of topics received at 9 PM on 15-07-2020
1
2
3
4
5
6
7
select topic,count(*) from MESSAGE_ARCHIVE
WHERE
trunc(WHENRECEIVED)=to_date('15-07-2020','DD-MM-YYYY')
AND EXTRACT (HOUR FROM CAST (WHENRECEIVED AS TIMESTAMP)) > 19
GROUP BY topic
ORDER BY count(*) DESC
;