SQL - Part 63 - Using Any Operator in Multi Row Sub Query

[@pranavdaine9721]

Select * from Products where ProductID < any (SELECT ProductID FROM OrderDetails where Quantity=1); sir this query in not running in w3schools plz check

[@hritikchauhan3892]

yes , not running

[@shubhamsinghvi1289]

Hello Sir, Again Back with a new Question How We Can differentiate which time we need to use which Query/SubQuery Concept and Join Concept. Because in the Previous Video for IN Operator you use Primary key Concept same as Like we use in Joints. So Can you explain it with a Comment or in a video If Possible

[@jbhargav7181]

Sir We have full SQL course video

[@QAFox]

Yes, you can find it at kzbin.info/aero/PLsjUcU8CQXGFFAhJI6qTA8owv3z9jBbpd

[@jbhargav7181]

@@QAFox Tq so much sir this is very useful to me and your explaining like taking example it was very easy to understanding us

[@QAFox]

@@jbhargav7181 Welcome :)

[@jbhargav7181]

Sir we have class about logical and physical components in SQL

[@QAFox]

@@jbhargav7181 No, I have not covered them.

[@hritikchauhan3892]

sir NOT IN nahi kar sakte kya ??

[@arkadatta6180]

< any nehi kam raha