SQL Query Help: Selecting Rows That Appear A Certain Number Of Times

date, select, sql

Solution

select dates 
  from table t 
 group by dates having count(dates) < k ;

Hopefully, it works for ORACLE. HTH

Problem

I have a table with a "Date" column. Each Date may appear multiple times. How do I select only the dates that appear < k number of times?

Original source