Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 count the number items in a table

Author  Topic 

Phaswana
Starting Member

1 Post

Posted - 2013-05-23 : 17:47:22
i have table A and B such that A(1,2,3,4,5) and B(1,1,1,1,1,1,2,2,3,5,5,5,6,6). now I want to count the number of items in A that exists in B including the ones that don't exists in B then show them as table C such that C(1=6,2=2,3=1,4=0)

how can i do this?

PM Malatjie

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-05-23 : 18:02:48
[code]select
a.col,
count(b.col)
from
a
left join b on a.col = b.col
group by
a.col;[/code]
Go to Top of Page

philipcarter99

1 Post

Posted - 2013-06-11 : 05:17:37
Hi ,i had the same query where i couldn't find exact code ..really loved it ..Thank u guys for posting this solution .

unspammed
Go to Top of Page
   

- Advertisement -