Explain CLAUSE in SQL?
It is the source of a rowset to be operated upon in a DML statement. These clauses are very common which is used with Select statement, Update statement and Delete statement.
SQL provides with the following clauses that are given below:
- GROUP BY
- ORDER BY etc