I work on sql server 2014 i need to get rows that have source type 484456
when group by two columns group by GivenPartNumber_Non and vcompanyid
so i need to make select query display every group of rows by GivenPartNumber_Non and
vcompanyid have source type 484456 only may be this group one row or 2rows or 3 rows or
more etc any way i need to retrieve it .
sample data
create table #notmappedsources
(
GivenPartNumber_Non varchar(200),
vcompanyid int,
SourceType int
)
insert into #notmappedsources(GivenPartNumber_Non,vcompanyid,SourceType)
values
('ADFGH22',1233,484456),
('ADFGH22',1233,484456),
('ADFGH22',1233,484456),('XFDY990',5489,484456),
('XFDY990',5489,484456),('GX84322',2549,484456),('LKHG23',3201,484320),
('LKHG23',3201,484320),
('LKHG23',3201,484320),('DGHJ66',7041,484320),('FDYH36',8901,484320),
('FDYH36',8901,484320),('MNH32',5601,489561),
('MNH32',5601,489561),
('MNH32',5601,484456),('NUI34',9076,489561),('KLMD33',5022,489561),
('KLMD33',5022,484456)
what i try as below :
select GivenPartNumber_Non,vcompanyid from #notmappedsources
where SourceType=484456
group by GivenPartNumber_Non,vcompanyid
expected result as below :
GivenPartNumber_Non |
vcompanyid |
SourceType |
ADFGH22 |
1233 |
484456 |
ADFGH22 |
1233 |
484456 |
ADFGH22 |
1233 |
484456 |
XFDY990 |
5489 |
484456 |
XFDY990 |
5489 |
484456 |
GX84322 |
2549 |
484456 |