Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable ( due_date DATE);
INSERT INTO mytable VALUES(sysdate - 2);
1 rows affected

INSERT INTO mytable VALUES(sysdate - 1);
1 rows affected

INSERT INTO mytable VALUES(sysdate);
1 rows affected

INSERT INTO mytable VALUES(sysdate + 1);
1 rows affected

select to_char(due_date, 'yyyy-mm-dd hh24:mi:ss') due_date from mytable;


DUE_DATE


2019-10-10 22:12:09

2019-10-11 22:12:09

2019-10-12 22:12:09

2019-10-13 22:12:09


SELECT *
FROM (
	SELECT *
	FROM (
		SELECT 'due' reason, COUNT(*) cnt FROM mytable WHERE TRUNC(due_date) > TRUNC(sysdate)
		UNION ALL SELECT 'not due', COUNT(*) FROM mytable WHERE TRUNC(due_date) < TRUNC(sysdate)
		UNION ALL SELECT 'due today', COUNT(*) FROM mytable WHERE TRUNC(due_date) = TRUNC(sysdate)
	) 
	ORDER BY cnt DESC
)
WHERE ROWNUM = 1


REASON
CNT


not due
2