Selection of Single Instance from Multiple Keys - How Do I

[cartw19]

I have a table with multiple occurences of key values, how do I retrieve the first row only on a Select statement.

 

[swampBoogie]

First is not a relational concept. Records in a table does not have a specific order, they are only identified by the values in the columns.

To get the highest value with each group you can use

select pk1,max(pk2) from t group by pk1