What is the difference between WHERE and HAVING clauses?
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Please Disable the AdBlocker to Continue to the site.
Where clause is used to filter the table based records based on a specified condition.
Having clause is used to filter the group based records based on a specified condition after group by clause.
Where clause can be used with insert, update, delete.But Having clause can not be used with insert, update and delete
Where clause comes before group by and having clause comes after group by