SQL DELETE

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Hi
 
I have this table :
 
Code  Client    SeqNo
A     123       10
A     123       20
A     123       30
B     123       40
B     123       50
A     456       35 
A     456       30 etc

I want to delete lines so I keep only one line for each pairing of Code and Client. The SeqNo must be the highest number for the pair.
 
So my table after delete should be :
Code  Client    SeqNo
A     123       30
B     123       50
A     456       35 


Thanks for any help. 

PS what's happened to Elvis Budimlic?