Following is a result of a query using ROW_NUMBER() with partition
Assuming that this result is stored in a table variable 'RESULT',, I want to select only the barcodes with one row. All the barcodes with maximum ROWNUM >1 should be ignored. In the example i gave, row with id 4 only should be returned.
Can anyone help?