Which are Pseudo Columns? | Complete Guide

In this article, we will see Pseudo Columns and its use. This is one of the popular interview question. At the end of this article, I also captured the video tutorial for your better understanding. So make sure to watch that video as well. Let us see what are Pseudo Columns and its use. Here … Read more

How to Create a Table in SQL? | Simple Example

In this article, we will see how to create a table in SQL with examples. Before we discuss on that let us see the importance of table in SQL. What is a table and Why we need to create a table in SQL? A table is a physical storage area to retrieve the rows and … Read more

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