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

Recommended Answers

All 2 Replies

select id,name,no_items,count(*)
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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.