unique pair of columns

[gandolf989]

Originally posted by lgaorcl
The table has three columns for example, label, sid, s_size.

The view wants these three columns with unique combination of sid and s_size.

Thanks!

Why don't you just do this?

SELECT DISTINCT label, sid, s_size
  FROM the_table;