Subquery in SQL || SQL Subquery tutorial with examples

In this video we have discussed SQL Subquery in a very simple way with examples. Here we have discussed about single row subquery, multi row subquery, correlated subquery and how subqueries can be used in where clause, select clause and from clause. Different important queries are discussed using subquery which are very important for interviews.

Please Find SQL Commands to create Employee and Department table to practice:

Please like & share the video.

Subscribe the Channel to keep watching intresting videos helpful for your career growth:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout Important videos :

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

[CodingGlitz]

LinkedIn:

Please Find SQL Commands to create Employee and Department table for practice:

[hamzanalwala]

This channel is pure GOLD i repeat its pure GOLD. The intrinsic details that are mentioned in the videos, show that a lot of thought process had been put to make them ... Thank you so much. May you reach millions soon

[tqolgfd]

Best video on subquery and the best channel for beginners to learn SQL.

[rohitamalnerkar]

Such articulate and to the point explanation on subqueries. Loved it man!

[anilkumarjena]

Awesome! You cleared the clean concept of subquery, Thank you sir.
Please share with more complex query as well to get more understanding

[goutammishra]

Great Explanation Brother ...!
You are doing a good job, keep it

[tusharsonwane]

Superb super superb explanation sir thank you so much🙏

[mohitpatil]

very good explanation of subquery. Thankx

[thatmaskguy]

They way you explain the concept it feels like big brother is teaching ❤ thankyou bhaiya for making these concepts clear and easy to understand for non IT people ❤️

[shantinathudgave]

Sir, I have created Web Software using queries only as per your guidance. It works very efficiently and very fast.

[OAVBellagunthaPractical]

excellent video... best sql video i have seen till now.

[ushasworld]

Don't stop Making videos sir ur videos are very useful thanks alot for ur efforts

[oceanpearl]

This is by far the best SQL tutorial channel i ve ever watched. You show the best tips and tricks here Sir. Huge Respect! 😊

[bhavikaparihar]

Seriously best video I have ever seen on sub queries and co related queries

[maynk]

Very Polished video with good clarity. Thank you.

[jfeqlih]

Superb explanation. i found this video by chance and it helped to clear many concepts. thanks for explaining with great examples.

[pgpywyu]

appreciate your efforts.valuable topics like dense_rank, subquery in select and from clause are explained nicely in a single video.

[muskansrivastava]

Thanku again for this lecture, you really explain small details in a great manner .I'm just glad I found this channel.

[AnilKumar-nbic]

Very useful video sir.
As you explained in second last syntax. Co-related subquey with empname and their manager name..
But can we used the below script for extract the same output?
Select ENAME, MGR from emp;

[ghanshyam]

All subqueries are well explained and demonstrated 👍