Querying JSON in SQL Server

In SQL Server 2016 they added support for handling JSON data. You can add JSON data, query it, and modify it. The JSON API in SQL Server is well-suited for simple scenarios where you only need to do basic querying and manipulation. For advanced querying, the SQL Server JSON API gets complicated and hard to … Read more Querying JSON in SQL Server

SQL – Use HAVING to filter GROUP BY

WHERE filters individual rows. HAVING filters aggregated rows. When you use GROUP BY, you are grouping rows together into aggregated rows. How do you filter the aggregated rows? You use the HAVING clause. Example of using HAVING Let’s say we want to see all NFL divisions where all teams have played in the Super Bowl … Read more SQL – Use HAVING to filter GROUP BY