Top Answers

1. Fetch the rows which have the Max value for a column for each distinct value of another column
   441 votes
2. What's the difference between TRUNCATE and DELETE in SQL
   305 votes
3. What is the difference between a hash join and a merge join (Oracle RDBMS )?
   88 votes
4. How do you interpret a query's explain plan?
   82 votes
5. When and why are database joins expensive?
   49 votes