#beginners
Read more stories on Hashnode
Articles with this tag
In this episode we will be discussing a key concept of SQL and database administration, we will be inserting a new record into a table. We will be...
Many times we have to look at how many characters there are in a string. Sometimes we even need to find the position of a character or a set of...
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...