In this tutorial, we’ll discuss SQL temp tables and views. These two can be handy if you want to pull a specific set of data from a physical table for testing and debugging. We’ll also talk about the 2 types of temporary tables and their differences. With SQL temp tables and views, you can freely
Category: SQL for Power BI
In this blog, we’ll discuss how to filter in SQL. We’ll explain and show some examples utilizing filtering conditions such as IN, NOT IN, LIKE, and NOT LIKE. These filtering conditions are used to filter the output from the data. Instead of selecting them using multiple lines of commands, it will be easier for you
In this tutorial, we’ll be discussing the different aggregate functions in SQL and how we can use them. In SQL, aggregate functions are used to accumulate data from multiple rows into a single summary row. Aggregate functions in SQL can be very helpful for analysts when doing data summarization. Commonly Used Aggregate Functions In SQL
In this blog, we’re going to discuss stored procedures in SQL that you can utilize to save a set of code and use it repeatedly whenever you need it. Stored procedures are similar to views. However, you can conduct common table operations such as DROP, TRUNCATE, DELETE, etc. with stored procedures which you can’t perform
In this tutorial, we’ll be discussing a few ways in which we can use or execute the HAVING Clause in SQL aggregate functions. Using this clause in SQL aggregate functions can greatly help in data summarization. HAVING Clause is almost similar to WHERE statement and can also be executed along with it. We’ll discuss their