WRKQRY - How to select distinct records?

The File I need to extract is as follows

12345 ABC 12456
12345 ABC 43535
12345 ABC 5367437
555 CDE 775757
555 CDE 9499494
555 CDE 94994

How do I select only one record of each of 12345 ABC and 555 CDE instead of duplicate records

Define a report break containing both fields. Then in Select Output Type, choose Summary Only. You will only see one occurrance for each distinct break level. The one downside to this is that Query/400 will insert a blank line in between each row. If you want to print out the data without the blank lines, you can run the output of this query to a temporary file and then query the temporary file seperately.