What are clauses in SQL? Explain the uses of WHERE, ORDER BY, and GROUP BY clauses.

Question

Accepted Answer

A clause is a part of an SQL statement that adds extra conditions, rules, or arrangements to control how data is retrieved, updated, or deleted. WHERE filters records based on a condition, for example SELECT FROM Student WHERE Age 15; ORDER BY sorts the result in ascending or descending order, for example SELECT FROM Student ORDER BY Age DESC; GROUP BY groups records that have the same values in specified columns, which is useful for producing summarized results such as counting the number of students per class.