It would be incredibly powerful if we were able to do a Select Distinct/Unique on a given result set.
I'm thinking something similar to how this is done in PowerShell:
Get-Process | Select Name, Path -Unique | Sort Name
Have a look at the following post that talks about the DISTINCT operator, and let me know if it works for your scenarios.
If it's possible, it is not listed here: