drop table #SampleData
create table #Sampledata
(
WONum int , OpNum int
)
insert into #Sampledata select 1396026,40
insert into #Sampledata select 1396026,90
insert into #Sampledata select 1396026,90
insert into #Sampledata select 1396026,120
insert into #Sampledata select 1427600,130
insert into #Sampledata select 1456392,120
insert into #Sampledata select 1456392,130
insert into #Sampledata select 1458018,230
insert into #Sampledata select 1458018,280
insert into #Sampledata select 1460224,40
insert into #Sampledata select 1460224,80
select 'Sample Data ', * from #SampleData
select 'SQL Output',WONum ,max(OpNum) from #Sampledata group by WONum