Clauses are used in SQL to filtering , sorting and Grouping.
In SQL we use different types of clauses. They are
1. where
2. having
3. order by
4. group by
Top is not working Oracle.
WHERE Clause
It is used to filter the records based on the condition.
it is used to to sort the records either ascending or descending order
GROUP BY clause
it used in the grouping of records. it used in aggregate functions.
HAVING Clause
it also used to filter the records.But it is used after using group by clause. before group by we can use where clause.