How to Delete Duplicate Rows in SQL? | SQL Queries

In this article, we will discuss how to delete duplicate rows from a table in SQL server This is a very common SQL interview question. Here is the table with duplicate data, notice that mark record is duplicated 3 times Marry record 2 times and Ben record 3 times. Now the delete query that we … Read more How to Delete Duplicate Rows in SQL? | SQL Queries

What are the types of Triggers in SQL? | A Complete Guide | Updated 2020

In this article, we will discuss what is a trigger and different types of triggers in SQL. It is one of the most important topics also it comes under frequently asked interview questions. Beginners often think it is a very complicated topic and difficult to learn. Here I will teach you everything step by step … Read more What are the types of Triggers in SQL? | A Complete Guide | Updated 2020

What are The Different Types Of SQL Commands? | SQL Queries

This article will describe the different types of SQL commands and their use. I will show you a step by step overview of different types of SQL commands that we commonly use. So that you will have a very clear understanding of this topic after reading this article. In general SQL commands are the predefined … Read more What are The Different Types Of SQL Commands? | SQL Queries

What Is SQL HAVING CLAUSE and How Does It Work? | SQL Queries

In this article, we are going to discuss SQL Having Clause in SQL Queries for various scenarios. By reading this article you will be able to know everything about SQL Having Clause. The SQL Having clause is used to specify a condition on aggregate functions and it is used along with the group by clause … Read more What Is SQL HAVING CLAUSE and How Does It Work? | SQL Queries

What is SQL Server Management Studio? | Updated 2020 | SQL Queries

This is a brief introduction to the SQL server management studio. For beginners, I will just cover the basic UI components and a few simple tasks that you can do. Here I have connected to SQL Server Management Studio.  The first thing that asks me to do is connect me to a server. Management studio … Read more What is SQL Server Management Studio? | Updated 2020 | SQL Queries

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. You must answer this question because Pseudo columns are frequently being used in SQL queries and it resides almost every table. Let us see what are Psedo Columns and its use. Here I have displayed the … Read more Which are Pseudo Columns? | Complete Guide

How to Create a Table in SQL? | Updated 2020 | SQL Queries

In this article, you will be able to know how to create a table in SQL with simple steps. It is a very basic SQL concept and also it is a frequently asked interview question as well. By reading this article you will become a master in SQL table creation. I have created a sample … Read more How to Create a Table in SQL? | Updated 2020 | SQL Queries

SQL Joins with Practical Examples

This article will help you to understand everything about SQL joins. These joins are very important and which are frequently asked during interviews. SQL joins are basically 4 types. These joins are used to combine results from two are more tables. Inner Join Left Outer Join Right Outer Join Full Outer Join Inner Join Inner … Read more SQL Joins with Practical Examples

What is the difference between Union and Union ALL? | SQL Queries

Here we will see the practical examples after reading this article you will be able to understand the major difference between union and union all. This is one of the commonly asked interview question. One should answer this question because it is a very basic question in SQL People often confuse when an interviewer ask … Read more What is the difference between Union and Union ALL? | SQL Queries

What is Row Number, Partition, Rank and Dense Rank?

In this article, we will see what is Row Number, Partition, Rank and Dense Rank. These are frequently used SQL functions that an interviewer can ask during the interviews. Let us understand Row Number, Partition, Rank and Dense Rank with practical examples. Row Number Partition Rank Dense Rank Rownumber and Partition with Practical Examples In … Read more What is Row Number, Partition, Rank and Dense Rank?