How to Write Simple Subqueries in SQL?

In this article, we will see what is sub query in SQL and its use. Also we will write simple sub queries with practical examples. In simple words a 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 … Read more

What is the cluster in SQL? | Complete Guide 2021

In this article, we will see what is cluster in SQL and what purpose cluster will be created. A cluster in SQL is a database 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 are the Unique key and Primary keys in SQL?

What are the Unique key and Primary keys in SQL? In this article, we will see What is the Unique key and Primary key in SQL? This comes under one of the most frequently asked interview questions. Before we discuss the difference between these two let us see what is the primary key and unique … Read more

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 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 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 Date Functions in SQL | Practical Examples?

What are The Date Functions in SQL With 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 … Read more