In some cases, we need to combine the result of two tables where data types may be similar or identical. We could combine the data in one table using INSERT syntaxes, but with UNION ALL or UNION, we can achieve the same result instead of creating a new table. In…

In a previous lesson, we learned that we can apply ROW_NUMBER() to a data set and output the row number of the data set based on the order we specify. This means that if we have an alphabetized list, we could have ROW_NUMBER() return that list in an ascending or…

If we think about functions in mathematics, we’ll recall that one function is the division function. If we have 10 apples and we want to divide them equally into 2 containers, there will be 5 apples in each container. If we have 10 apples and 10 containers and we want…

SQLInSix Minutes

Data | Development | Security.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store