MSSQL add count column near existing select columns

[end3r]

Hy,

I seek your help in solving the following problem:

I have a select which returns columns like ( without count_same which I need to create by counting the same name):

ID | NAME | no_items | count_same
-----------------------------------------------------------
1 | A | 1 | 2
2 | A | 0 | 2
3 | B | 1 | 5
4 | B | 1 | 5
5 | B | 1 | 5
6 | B | 1 | 5
7 | B | 1 | 5

I'm still in the learning phase of SQL and I do not know how this problem can be solved.

Thanks in advance guys,
Ender

[Aussie_Here]

select id,name,no_items,count(*)

[end3r]

select id,name,no_items,count(*)

Thanks!

This solves one big part of my problem. I don't know why I didn't think about this in the first place...

So the resolution - case solved.