Filtering a computed column or field in SQL can be a little tricky. Find out how filtering computed columns in SQL works using datagy’s easy guide!
Category: SQL
In this post, we’ll learn how to use several SQL functions to calculate age, including the GETDATE(), DATEDIFF(), and FLOOR() functions. Knowing how to combine these functions can allow us to readily calculate data without having to import data into other platforms such as Excel.
SQL’s one of those skills that any aspiring data analyst or data scientist really needs! It’s used everywhere, easy to learn, and allows your to do really awesome things. Dive into SQL using datagy’s “Getting started with SQL” guide!
Subqueries in SQL allow you to embed a query within another query. This post will show provide you an introduction of what you can accomplish with subqueries and lead to some more advanced exploration.
There may be instances in which we’re only interested in returning limited values from a query. For example, we may only be interested in returning … Read More ›
SQL also has built in tools for ordering the data in the table it returns. This is done using the ORDER BY key word, which … Read More ›
One of the most powerful features in SQL is the ability to join tables based, to bring in more information than exists in one table … Read More ›
Let’s take a quick look at what makes up our sample database, which in this case is only made up of two tables. Let’s pretend … Read More ›
Let’s dive a bit more into SQL. At its minimum a SQL search query only requires two key words: SELECT and FROM. With SELECT, we … Read More ›
Let’s say we didn’t really need to pull at the columns in a given table. We could modify our query from above to specify which … Read More ›