Articles on SQL, TSQL and Management Studio. You can download Microsoft supplied sample database here:

Self Join SQL Example
SQL Server

Table Join Explored With Examples

“Table Joins” are useful for bringing data together from different tables based on their database relations. First, we will see how the join operates between tables. Then we will test the Order of Execution when Join and where condition both lies. Finally, we will move our exploration to Importance of the Join order. It is a good idea to know about database table relationships before reading this article.

SQL Query with Aggregate, Group By, Order By and Having with Where conditions
SQL Server

Learn How to Use Order By Clause and Group By Clause

1. Introduction to Grouping & Sorting In this article, we will explore group and sort the result of an SQL query. The Order By informs SQL engine to arrange the query output in ascending or descending order. To put it differently, the Order By will sort the output query result on a specific column or columns. We … Continue reading