select p1.Group, p1.Sub_group, count(p1.personid)
from prod1 p1,
(select Group, sub_group
from prod1
MINUS
select Group, sub_group from prod2) p2
where p1.Group = p2.Group
and p1.sub_Group = p2.sub_Group
group by p1.Group, p1.Sub_group
Hello This is a little space on the internet cloud, which I can say is mine. I started this blog with the intention of writing some good .NET articles, but slowly I am also writing some of the myths and realities of H1B. [update Aug 18 2009] I have recently found my interest towards reducing greenhouse gas emission and other GREEN things. Join me for GREEN I have gone through a lot of things, and like to share my experiences. I hope this helps someone, the only purpose of this blog.
No comments:
Post a Comment