Tag: SQL Server Management Studio

Common SQL Table Expressions For Power BI Users

Common SQL Table Expressions For Power BI Users - Enterprise DNA

In this blog, we’ll discuss some common table expressions, also known as CTEs. If you encounter complex problems, using these SQL table expressions can help you. With CTE, you can break any task into small and manageable queries to solve complicated problems. Now let’s explore how CTE can make your work more efficient in troubleshooting

Continue reading

SQL Data Extraction Using OFFSET And FETCH

SQL Data Extraction Using OFFSET And FETCH - Enterprise DNA

In this blog, we’ll discuss OFFSET and FETCH. These two – when combined – are very powerful and can help us with our SQL data extraction tasks. We can use these two to extract data based on our requirements or needs. The purpose of OFFSET is to skip the first rows that you have mentioned

Continue reading

Subquery In SQL For Power BI Users

Subquery In SQL For Power BI Users - Enterprise DNA

In this tutorial, we’ll learn and understand how we can utilize a subquery in SQL. A subquery is a query within another query. We can also call it a nested query within a larger query. It must be enclosed with a bracket and mostly used in a WHERE clause. We can utilize subqueries in SQL

Continue reading

Common SQL Functions: An Overview

Common SQL Functions An Overview - Enterprise

In this tutorial, we’ll learn common functions that we can use in SQL. These functions can be a String or a Date. SQL functions are used for processing or manipulating data. Let’s first talk about the String functions. These are the SQL functions that we usually use for manipulating String characters or String values. Common

Continue reading

SQL WHERE Clause For Filtering Data

In this tutorial, we’ll discuss what the SQL WHERE clause is and how to use it. We’ll also talk about multiple conditions by using AND and OR operators.  The SQL WHERE clause is for filtering data or records. It’s used to create a condition to extract only the necessary records needed.  Aside from using the

Continue reading