SQL Joins with Practical Examples Updated(2021)

In this article, we will see the different types of SQL joins with practical examples. This is one of the most important topics in SQL. SQL joins are basically 4 types. Inner Join Left Outer Join Right Outer Join Full Outer Join These joins are used to combine results from two are more tables. Inner … Read more

The Major difference between UNION and UNION ALL? | SQL Queries

Here we will see the major difference between union and union all with practical examples. After reading this article you will have a very clear understanding of this topic. It is one of the commonly asked interview questions. One should answer this because it is a very basic concept of SQL. We often confuse when … Read more

What are Row Number, Partition, Rank, and Dense Rank? 2021

In this article, we’ll understand what’s Row Number, Partition, Rank, and Dense Rank. These are frequently used SQL functions that an interviewer can ask during the interviews. Let us dig into this topic and try to understand Row Number, Partition, Rank and Dense Rank with practical examples. Row Number Partition Rank Dense Rank What are Row Number, Partition, Rank, … Read more