0

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

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by end3r
0
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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.