If you look at the article by shabbir about Delete duplicate rows from Oracle you will realize the power of each of them and why you should be using them as much as possible. Also if you can use PL/SQL or T-SQL of Oracle / SQL Server your application will be much more efficient and so concentrating on general queries is good to start off but not a good solution for optimal performances.