How to count consecutive rows in SQL?

In this article, we will see how to count consecutive rows in SQL. This is one of the most important and commonly used real time SQL concept. At the end of this article I have captured the video tutorial for your better understanding. So make sure to watch that video as well. SQL count consecutive … Read more How to count consecutive rows in SQL?

What is the Use of a truncate table in SQL?

Use of truncate table in SQL Let us see what exactly is the truncate table in SQL and what is the use of it. At the end of this article, I also captured the video explanation for your better understanding, so make sure to watch that video as well. So what is truncate table in … Read more What is the Use of a truncate table in SQL?

How to Write Simple Subqueries in SQL?

In this article, we will see what is sub queries in SQL and its use with practical examples. Sub query is nothing but a query inside query. Many times you would like to have a series of SQL chained where an output of one query is sent an input to the other query for filtering … Read more How to Write Simple Subqueries in SQL?

What is cluster in SQL? | Complete Guide 2020

In this article, we will see what is cluster in sql and what purpose cluster will be created. A cluster in sql is a databasee object that stores data related to two are more tables in a single disk space. Single disk space means single memory location that is called blocks. Segments and Memory Locations … Read more What is cluster in SQL? | Complete Guide 2020

What is Unique key and Primary key in SQL?

What is Unique key and Primary key in SQL? This is one of the most frequently asked interview question. Before we discuss difference between these two let us see what is primary key and unique key. What is Primary key? Primary key is the key which uniquely identify each and every record in the table. … Read more What is Unique key and Primary key in SQL?

What is the use of Coalesce in SQL Server?

In this article, We will understand how to use Coalesce in SQL Server with examples. The dictionary meaning of Coalesce is combine (elements ) in a mass or whole. According to the MSDN books online Coalesce in SQL Server returns first non null value. Let us understand what we mean by this. ID Customer First … Read more What is the use of Coalesce in SQL Server?

What are the Scalar Functions in SQL? Complete Guide

In this article we will see the Scalar Functions in SQL with practical examples. Scalar Functions Scalar functions always return a single value using the given input value. Following are some of commonly used scalar functions. It is also one of the important interview question. Your interviewer may ask you what are the Scalar Functions … Read more What are the Scalar Functions in SQL? Complete Guide

What are SQL Window Functions? | Complete Beginner’s Guide

In this article, we will see what are the SQL Window Functions and common issues that we face with practical examples. SQL Window Functions We have 3 different categories of window functions, which are given below. Aggregate Functions – These are AVG, SUM, MIN, MAX, COUNT e.t.c Ranking Functions – These are RANK, DENSE RANK, … Read more What are SQL Window Functions? | Complete Beginner’s Guide

What are the SQL Aggregate Functions? Complete Guide

In this article, we are going to discuss SQL Aggregate Functions using practical examples with syntax. List Of Aggregate Functions Below are the commonly used SQL Aggregate Functions. AVG – Returns the average value for the selected column in the table COUNT – Returns the number of rows for the selected column in the table … Read more What are the SQL Aggregate Functions? Complete Guide

What are The Date Functions in SQL | Practical Examples

In this article, we will discuss Date Functions in SQL with real-time scenarios. Here I will show you the practical scenarios with syntax so that you can write your own SQL Queries depending on your requirements. At the end of this article, I also captured the video tutorial for your better understand. So make sure … Read more What are The Date Functions in SQL | Practical Examples