I am sorry if the question is silly because i'm new to SQL Server. I want to select top 5 records for each day of specified month.e.g. \[code\]top 5 records for day 1 in month septembertop 5 records for day 2 in month septembertop 5 records for day 3 in month september..top 5 records for day 31 in month september\[/code\]and show these all records as a one result.