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