Sub Queries

preview_player
Показать описание

IMPORTANT LINKS:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Рекомендации по теме
Комментарии
Автор

Sub queries are actually doing cross product internally...It's just a different style of writing cross product..

IoTLearner
Автор

For the last query about listing movie title directed by Karan Johar, will the following query work ?

SELECT Title FROM Movies WHERE Mid = (SELECT Mid FROM M_Director WHERE Pid = (SELECT Pid FROM Person WHERE NAme = 'Karan Johar'));

mohammadashikurrahman
Автор

It would be better if you zoom on the queries that you write on terminal

saumyatyagi
Автор

I think you just gave me a couple more points for my exam tomorrow. Finally i understand which situations i'm supposed to use subqueries! Thanks, man.

Messetify
Автор

this is awesome lecture, , really helped me.. please techtud upload more lectures

nileshlandge
Автор

Where to get this database of Movies.. Any link?

kartarsingh
Автор

Sir, please can you show your original database table of movie.

bv-qy
Автор

Thank-you sir this vedio is really very usefull
Thanx

sauravrajhans