What is the Use of 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 provided the video explanation, so make sure to watch that video as well. It simply removes all the rows from the table. The … Read more What is the Use of truncate table in SQL?

How to Write Simple Subqueries in SQL?

In this article, we will see what is subqueries in sql and its use with practical examples. Subquery is nothing but a quey inside query. Many times you would like to have series of SQL chained where an output of one query is send an input to the other query for filtering and manipulation. For … 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

How to connect to the SQL SERVER MANAGEMENT STUDIO?

SQL Server Management Studio is a client tool that can be used to write and execute SQL queries in the Database SQL editor. To connect to SQL Server Management Studio We need to do the following things. Click on the start button in your computer Click on All Programs Choose Microsoft SQL Server 2008 or … Read more How to connect to the SQL SERVER MANAGEMENT STUDIO?