mercredi 13 janvier 2016

SQL How to select first match if key has multiple values

Folks,

I have the following table...

Code UPC
1111 A
1111 B
1111 C
2222 B
2222 A

I need to return a table where only one UPC is returned per code (any code), so for table below result should only be 2 rows such as...

Code UPC
1111 A
2222 B

Appreciate any pointers.

Aucun commentaire:

Enregistrer un commentaire