Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
group by
SQL Server Data Validation Introduction
This post is about validating data in a single table. We have gathered data from the Internet and […]
SQL Server Aggregate Window Functions
Aggregate window functions in SQL Server are similar to grouped functions (SUM, AVG and so on) except that […]
SQL Server Window Functions
Window functions are used in SQL Server to perform data-analysis calculations. A data-analysis calculation is one you apply […]
SQL Server Summarizing Data Part 4
This post is part of the series on summarizing data but it gives us a more simple example […]
SQL Server Summarizing Data Part 3
In the previous post we covered summarizing data using the following words: select, from, where, group by, having […]
SQL Server Summarizing Data Part 2
Criteria As we continue from our previous post, here is another example of summarizing data. We are continuing […]
SQL Server Summarizing Data Introduction
For a simple example on summarizing data, please have a look at Part 4 of this series. This […]