I have a requirement where I have different IDs but I want to show the count of total no of rows in the table in every row.

Example:
I have total 5 rows in my table

ID  |   Date    |   Name
1       1 Jul       A
2       1 Jul       B
3       1 Jul       C 
4       1 Jul       D 
5       1 Jul       E  

I want to show the count of all rows in every row after the name column, something like this

ID  |   Date    |   Name    |   Count
1       1 Jul       A            5
2       1 Jul       B            5
3       1 Jul       C            5 
4       1 Jul       D            5 
5       1 Jul       E            5    

I have tried doing it with Count(*) but it requires a group by clause which is not outputting the desired result.

Any help would be highly appreciated.