Return values on max date

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

image