LIMIT (not part of SQL92, DB2 has a FETCH FIRST n ROWS ONLY CLAUSE) would be very useful when you what to find the top 3 Employee salaries (order by Salary Limit 3 ) or the bottom 3 Sales people (order by revenue generate Desending Limit 3 )