Coalesce Function in MSSQL

COALESCE is a built-in function in Microsoft SQL Server that returns the first non-null expression among its arguments. It takes one or more expressions as arguments and returns the value of the first expression that is not NULL. If all the expressions are NULL, it returns NULL. Continue reading Coalesce Function in MSSQL

Pivot Function in MSSQL

In SQL Server, the PIVOT function is used to transform rows into columns. The PIVOT function is a T-SQL operator that rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, effectively creating a cross-tabulation of the data. Here’s an example to help illustrate the concept: Continue reading Pivot Function in MSSQL

CTE (Common Table Expression) in SQL

CTE (Common Table Expression) is a feature in SQL that allows you to define a temporary result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement. A CTE is similar to a derived table or subquery, but has some advantages over those techniques, including improved readability, reusability, and optimization opportunities. Continue reading CTE (Common Table Expression) in SQL

SQL Window Functions

SQL Window Functions are a feature of SQL that allow you to perform calculations across rows within a set of rows, called a “window”. The window is defined using the “OVER” clause and can be used to perform operations such as ranking, cumulative sums, running totals, and more. These functions provide a more concise and efficient way to perform calculations that would otherwise require complex subqueries or self-joins.

Continue reading SQL Window Functions