SQL help - Select partial distinct...

I have a declare statement that I use for a fetch.
I am selecting INTO a host data structure, so I need to list out all the
fields I want in the select statement.
But I only want the 1st record for each duplicate key.  
 
ex:
1000, Blahblah.
1000, Blahblah again
2000, anotherone
2000, anothertwo
2000, anotherthree
 
So I want the select statement to only return the 1st and 3rd row, not
all rows, and I need both fields to return to the host data structure.
 
Is the solution that I have to retrieve the key value by itself, then
use that to retrieve the attached information?  I'd have no issue doing
this with RPG I/O but I think the Where clause performance would
outweigh RPG.   (Like vs %scan)
 
Thanks,  
 
Kurt Anderson
Application Developer
Highsmith Inc.
W5527 State Road 106, P.O. Box 800
Fort Atkinson, WI 53538-0800
TEL (920) 563-9571  FAX (920) 563-7395
EMAIL kjanderson@xxxxxxxxxxxxx