how to get top 4 date in a month

Try:

SELECT TOP 4 * FROM myTable WHERE DATEPART(year, @MATCHDATE)=DATEPART(year,[date]) AND DATEPART(month, @MATCHDATE)=DATEPART(month,[date]) ORDER BY [date]

The WHERE condition just allows you to provide a parameter to select the date - if your table only holds one month, then you can omit it.

Try this instead:

SELECT TOP 4 * FROM [tablename] ORDER BY date_field des

Please mark as answer and vote 5 if this solved your problem

Regards,
Eduard

Try this instead:

SELECT TOP 4 * FROM [tablename] ORDER BY date_field desc

Please mark as answer and vote 5 if this solved your problem

Regards,
Eduard