Query Logic

have a Table that has colums like ID, DATE.

My requirement is like this.
-------------------------------

I need to display 6 records at a time.
this table can have any number of Records for a particular ID.

The logic is like this.

the first record that is retrieved is always the Minimum date
the last record that is retrieved is always the Latest date

The remaining 4 records is the trick.

I need to find the Maximum Date in a particular month and pick that record. Now as i do this, if i find that the number of records are less than 4 then i need to pick up the records from the current month and make the count as 4.

The Constraint that i have
------------------------------

I dont want to use a Stored Proc to get this done.
I can have multiple SQL's to get this and i'll do a UNION ALL to display the 6 records.

Can anyone help me out in this

Thanks
Shankar