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 ›
Author: Nik
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 ›
When you develop a macro in Excel, it’s only available in the workbook you create it in – unless you add it to your Personal … Read More ›
VLOOKUP is an Excel function that can look up data in one Excel table and return it in another. The function runs similarly to the … 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 ›
Using SQL, you can develop powerful reports by aggregating data. In this post, we explore how to aggregate data using the GROUP BY clause and different SQL functions!