1. in a select query what is the difference between a where clause and a having clause?
In a SELECT Query, what is the difference between a WHERE clause and a HAVING clause? The WHERE clause specifies the criteria which individual records must meet to be selected by a query. It can be used without the GROUP BY clause. The HAVING clause cannot be used without the GROUP BY clause.