I have a table which store records of all dates of a month. I want to retrieve some data from it. The table is so large that I should only selecting a fews of them. If the records have a column "ric\_date" which is a date, how can I select records from each of the dates in a month, while selecting only a fews from each date?

The table is so large that the records for 1 date can have 100000 records.