Latest Posts

SQL Server Join Types with examples

SQL Server Join is an important concept for every developer to learn who deal with Database. Basically, Join facilitates getting data from multiple tables in a single query. In this article, we will learn how many different kinds of join are there in SQL Server and in what scenarios each join type can be used.

SQL Server Join Types:

SQL SERVER Aggregate Windows Functions with Examples

Database users are often required to calculate the Average or SUM of the total transaction done by the Customer or User in real-time scenarios. SQL Server Aggregate functions make the life of the developer easier to calculate SUM, AVERAGE, COUNT, MAXIMUM, and MINIMUM from the transactions done by the given Customer or User.

Aggregate Functions are always used to perform s..

CROSS APPLY and OUTER APPLY in SQL Server with example

SQL SERVER APPLY operator is very similar to JOIN operator where we get the final result set by