Correlated Nested Queries in SQL | Nested Queries | DBMS | GO Classes | Deepak Poonia

[@GOClassesforGATECS]

00:31:43 - Exists keyword with Count(*) - Exists with Aggregate Functions

[@curiousgamerx2037]

Very nice session understood everything

[@soumya8748]

Good ❌ Better ❌ Best 👍 Maja aa gaya❤

[@jsl_21]

wow the depth of concepts and level of questions were amazing. I think it will take me 2 days just to complete this lecture. Thank you deepak sir.

[@GOClassesforGATECS]

Glad you loved it. Keep watching, Keep learning!!

[@gauravrajpurohit882]

Tough topics are converted to Easy topics using the GO CLASSES machine. Wonderful explanation, with the question it makes more clear. Thank you, sir.

[@Bhaveshmaratha-m1v]

I have seen many videos on this topic but this what makes my concept crystal clear

[@gameoraim4937]

Best one

[@gate_dose]

Please Everyone Like the video.💯💯

[@_sourav_]

I like the videos even before watching it completely as I know it will be definitely worth liking😃

[@GOClassesforGATECS]

Thank you so much 😀

[@abhishekb1324]

1:24:53 sir in inner subquery can we use B.bid NOT IN ( Select R.bid From Reserves Where R.sid = S.sid and B.bid = R.bid )

[@Bhaveshmaratha-m1v]

This video's are like goldmines

[@nagendravoora8146]

A small doubt sir , In GroupBy clause we say that every attribute which is used in GroupBy should be present in select and anyother if we want need to be in aggregate function. Can I place attribute in GroupBy directly in aggregate function or we need to place it without any aggregate function. I have Tried placing it in only aggregate function in online compiler it worked . Can I follow it?

[@noneofyourbusiness2964]

we use SQL 92 standard in GATE so even if something works in compiler , there is no guarantee that it'll work in GATE