S
stw8
The following table is an example of my table.
I need to select all columns but col1 and col2 should not have duplicates.
I also need the first line of the group.
No. col1 col2 col3 col4 col5
abc ttc1 789 234 235
bdc yyr2 797 378 379
How do I get col1 and col2 to be unique.
I need to select all columns but col1 and col2 should not have duplicates.
I also need the first line of the group.
No. col1 col2 col3 col4 col5
My results should be:1 abc ttc1 789 234 235
2 abc ttc1 688 899 890
3 bdc yyr2 797 378 379
4 bdc yyr2 794 375 359
5 bdc yyr2 494 365 459
abc ttc1 789 234 235
bdc yyr2 797 378 379
How do I get col1 and col2 to be unique.