#sql-server
Read more stories on Hashnode
Articles with this tag
In this last entry, I want to revisit how Join operations work, we know so far they will match the data from one table to another table and pull the...
In this episode we are going to discuss how to extract characters from a string value. Let's say for instance, we wanted to pull data from the...
Sometimes we need to join the data from multiple columns or string values to get the desired result. Without wasting anytime lets dive into SSMS and...
Many times we might need to use aggregated values in our Where Clause, as a way of limiting the result set of aggregated values. You would think it...
In this episode we will be discussing the impact of NULL values in Aggregation. Null value means that a column does not contain any value. It is not...
In this episode we are going to explore two additional functions we can utilise to aggregate our data, namely SUM and AVERAGE (AVG). As the name...