SQL LIMIT/TOP/ROWNUM clauses for getting top Results

SQL LIMIT/TOP/ROWNUM clauses for getting top Results