hi Artnette
Is this what you are looking for ????
please click arrow to the left for DROP Create SAMPLE Data
drop table #sampledata
go
create table #sampledata
(
STC_PERSON_ID varchar(20) ,
L27_OTHER_CREDITS float,
CREDIT_TYPE_DESC varchar(10),
STC_MARK_ACAD_CREDNTIALS int
)
go
insert into #sampledata select '0007309',12.000000,'Waived',34428
insert into #sampledata select '0007309',3.0000000,'Waived',34429
insert into #sampledata select '0174200',6.000000 ,'Waived',45365
insert into #sampledata select '0174200',30.0000000,'Waived',45366
go
select * from #sampledata
go
It can done with MAX ???
please click arrow to the left for SQL ...
select
'SQL '
, STC_PERSON_ID
, max(STC_MARK_ACAD_CREDNTIALS)
from
#sampledata
group by
STC_PERSON_ID
go