Or is itor perhapsCode:SELECT label, sid, s_size FROM the_table WHERE (sid, s_size) IN (select sid, s_size from the_table group by sid, s_size having count(*) = 1);Code:select MAX(label), sid, s_size from the_table group by sid, s_size
|
Results 1 to 10 of 13
Thread: unique pair of columnsThreaded View
|
Click Here to Expand Forum to Full Width |