How do I create a view of unique rows

Hi. I have a table with lot of rows, with the value column repeated multiple times. I want to create a summary view of that table, with one row per value, and a sum of another column shown. I am able to create the sum column, but how do I generate a view that only has unique rows. What FIlter expression should I use?