Lec-59: SQL Queries and Subqueries (part-1) | Database Management System

0:00 - Introduction
1:52 - Question 1
3:38 - Question 2

► Structured Query Language (SQL)(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Database Management System(Complete Playlist):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
#Subqueries#SqlDBMS#freeEducationGATE

[GateSmashers]

Join Scaler Academy by InterviewBit, India's 1st job-driven online tech-versity.
Accelerate your tech skills in 6-months and land a job at the top tech companies globally.
300+ of our students have landed jobs with an salary range of 18-35 LPA at 150+ companies that include Google, Amazon & Microsoft.
No upfront payment. Pay us only after you get a high-paying job.

[relax]

To bnda kmal ka hai or samjata be kmal hai Allah Tumhe Iman ki dolat se nawazay Ameen❤️

[maheenriaz]

I am here to thankyou ♥️today i got second highest in dbms paper and full marks in dbms lab exam♥️♥️💯. ALLAH bless you ;)

[roshnisingh]

Sir, your SQL lectures literally helped me get a job!!! I cannot thank you enough..you are just too good at what you do...Keep helping students!! I pray for your well-being :) PS: I have completed almost all your computer science subjects lectures and keep referring to them while in doubt or maybe for quick revision.

[dadasajad]

thank you sir. one of the best dbms tutorials i have come across now.

[rishabhjha]

I think this is one of the fastest growing YouTube channel for GATE & other competitive exams.
The credit goes to this man Mr.Varun.Please redo these videos in English language so you could help more people.

[shirzadcrickethighlights]

thank you so much dear sir!
I am watching your videos from Afghansitan and I have got a lot expierance from your lecture so go ahead and we will keep you on prayer so keep it up .
I have never seen a teacher like you so again I really appritiated you sir

[bhupendrapsrasar]

wow sir apne jo smajhaya vo me kbse try kr rhi thi ab jaake smjh me aaya h😊😊 it was vre

[techbeauty]

Sir your all tutorial very helpful in our education. I am from Pakistan. I appreciate you to carry on such activities.

[renij]

Hey Varun. Thanks for explaining subqueries and nesting concept. I spent a good chunk of time on understanding it through other videos, but yours was the best. Thanks again :)

[dabhishreya]

Maine aggregate function abhi nahi sikha hein, phir bhi mein yeh achhe se samj payi *kyuki aapne yeh bahut badhiya smajaya hein* 🤗👌

[pixeelt-]

Nice one.. It really help me a lot.. Hope we get to see more lectures on more subjects.

[sangeetsingh]

All engineering lecturers must watch these lessons to understand how to explain DBMS concept..its one way communication yet explained so beautifully that one cannot have any doubts in the topic.. My lecturer simply read and copied from book and explaind easiest concepts because they themselves did not know the concept i percieve😷🤐.. Having said that, i must say not all lecturers are same..

[theunusual]

Thanks for video.
One correction at 5:36, subquery will execute for all the rows present in table.
So if there are 10 records in a table then inner query will compute the result every time and comparison will happen with that value for the given row. SO total 10 times inner query also would run.

[priyanshupandey]

bhai teri audience gate exam wali nahi h!

[deepalimahajan]

Hii. Varun
I am preparing for my SQL interview and your lectures is really very easy to understand. keep it up.
Thanks a lot.

[Staytruegoggins]

Thanks! Great content! Can an alternative approach be by using self join- SELECT Emp.E_name FROM Emp t1, t2 WHERE t1.salary>=t2.salary AND t1.name<>t2.name (If yes- which one would be more efficient)

[bhartisharma]

You are a great being! May you achieve all your dreams.

[harendrasaikia]

Any from class 10?? We also have this topic for Board Exam

[Javatechie]

Really your contents are awesome dude .the way you are explaining it's very simple so a layman can understand . please keep it up...

You should deserve more views and subscriber