Complete SQL Subquery Using Comparison and Logical Operators | SQL Tutorial in Hindi 13

SQL Full Course Playlist 👇

Like, Share & Subscribe Now :)

➖➖➖➖➖➖➖➖➖➖➖➖➖

Timestamps:
00:00 Intro
00:28 Subquery in SQL
01:27 Subquery Example Using Comparison Operator
02:11 Subquery practice in SQL
05:23 Subquery using IN Operator
08:01 Subquery using EXISTS Operator
➖➖➖➖➖➖➖➖➖➖➖➖➖

Target keywords: complete sql subquery, subquery tutorial, Subquery using comparison and logical Operator, nested query in sql, inner query in sql
➖➖➖➖➖➖➖➖➖➖➖➖➖

Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5

How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6

String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7

Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8

Group By and Having Clause in SQL | SQL Tutorial in Hindi 9

TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10

Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12

Useful videos
How to Become Data Analyst in 2022 | Data Analyst Roadmap

Data Analyst skills, jobs and Roadmap

Excel Tutorial for Beginners

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!

[meetpatel]

Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up!

[ReelgramJams-vmug]

bhai ap aise padhate ho jese revision karhe ho, apko as a newbie smjhana chahiye joki first time padhrha ho !!!

[PARESH_RANJAN_ROUT]

Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up! Love you Sir. We are so happy for your teaching. dill se thankyou aapko.

[vishaluniverse]

This video is about when a working professional teaches you. They will know every corner on how to make you understand the concept.

[UrwaRiaz-bmlw]

This video is very helpful for me
mene es se pehly bohat sari palylist ki or join wala topic samjhny ki koshish ki but phir b me paper me question krny ky qabil ni thi jesy h mene ap ki videos dekhi hy me join ky related kisi b qisam ka question achy se kr sakti ho
Thanks Again sir g👍

[wayzonic]

I got new concept "सब कुछ ", Thanks a lot.

[pranjalkastwar]

U are teaching like we are knowing every thing

[bgtjekw]

Thanks You explained in a easy and excellent way !!

[ManishKumar-niio]

Bhai SQL ka sara topic samajh aaya pr ye sub query utna clear nhi hua...😢

[souravtewari]

Very nicely explained, Rishab. However, I have one request regarding this particular video. Could you kindly mention the question for the "Logical Operator & Exist Operator" before starting the chapter? Just like you did with the question for the "Compression Operator" at the beginning, it would help provide more clarity. The rest is okay. Thank you.

[warwithlife]

Wow this was an amazing video, I came here just to solve my doubt about subquery but now feels to watch all of your videos about sql. Really amazing video and I will also promote about you on my channel soon when i start my channel. This is how real professional helps to learners like us.
I would like to connect with you over linkedin so if you don't mind please drop your connection link.

[rohitverma]

Sir there is record in column which is split through (, ). I want to remove every character that starts with coma and there are multiple like that in table. Is there a query which removes characters starts from coma now matter what there length is? Plez help

[Mr_Shadow__]

Rishab bhai ek video exadata par advantage
Aur normal database difference par video bana di bhai

[Filmplanet-uinx]

when you have used in operator what is the role of mode in the line ?

[DharmendraKumar-DS]

nice explanation...can you help me to understand the exact difference between IN and EXISTS operator in subquery...?

[ronitrana]

Sir ye date ka leya syntax bta degeye mtlb syntax kya hona chahiye

[pranjalkastwar]

Select * from customer where amount > avg(amount) is this correct

[Motivationhindi]

Sql ka ak pura video bhnay data analysis kh liy

[syedsheeryar]

Or sir existing table ke andr or data kese add kese krskte hain sir plz iska bhi jawab deden

[anilkumarjena]

Can we use join and subquery at a time? If yes, please help me with complete syntax with these 2 tables (customer and payment) to get output