Master SQL Queries (in 5 minutes) Part- 2

My article is for everyone! Non-members can click on this link and jump straight into the full text!!

This article continues with the first article of my Master SQL Queries Series. Where we discuss all the basic concepts and also see the use cases of it. Now it's time to discuss some of the advanced concepts of SQL and their use cases.

Table of content:

1. Subquery
2. CASE
3. WINDOW FUNCTION
4. View

Subquery

What is Subquery?

• A subquery is a SQL query nested inside another query.
• You can place Subquery in the WHERE, HAVING, FROM clause.
• Also with SELECT, UPDATE, INSERT and DELETE statements along with expression operator.
• It could be an equality operator or comparison operator such as =, >, =, <=, and Like operator.

Now it is time to see some example