What are some common clauses or filter used with Select Query in SQL ?
Below are some frequent SQL clauses/filter used in conjunction with a SELECT query:
WHERE clause - In SQL, the WHERE clause is used to filter records that are required depending on certain criteria.
ORDER BY clause - The ORDER BY clause in SQL is used to sort data in ascending (ASC) or descending (DESC) order depending on specified field(s) (DESC).
GROUP BY clause in SQL is used to group entries with identical data and may be used with aggregation methods to obtain summarized database results.
HAVING clause - in SQL is used to filter records in combination with the GROUP BY clause. It is different from WHERE, since the WHERE clause cannot filter aggregated records.
