distinct

If the amt of data being returned is high,

which would be more efficient to use a group by clause or the distinct keyword..

depending on what exactly you want to achieve, i figure you want this in a dwh environment and achieve the same result.

Try using the autotrace,analyzing the data and then see which costs less.