What is the difference between where and having clause in sql server

Share 0. Tweet 0. About the author. Kris Wenzel. Thanks for letting me know. I just fixed the heading, problem brushed away.

My pleasure! Thanks for reading the article and taking the time to leave a comment. Keep coming back! But it doesn't have to be this way. Close dialog. The following example returns the list of total employees for the respective departments having a Gross Salary is more than 23L. The following example returns the list of departments having an Average Gross Salary is more than 25L in descending order. The following example finds the eater foodie who has placed less than ten orders per year.

As per Wikipedia, " WHERE is taken into account at an earlier stage of query execution, filtering the rows read from the tables. I hope you enjoyed this article. View All. Onkar Sharma Updated date Sep 06, This means it is used to filter groups. Next Recommended Reading. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Note The query shown in the example for this procedure joins two tables, titles and publishers. Is this page helpful?