Select * from Products where ProductID < any (SELECT ProductID FROM OrderDetails where Quantity=1); sir this query in not running in w3schools plz check
@hritikchauhan38922 жыл бұрын
yes , not running
@shubhamsinghvi12892 жыл бұрын
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
@jbhargav71812 жыл бұрын
Sir We have full SQL course video
@QAFox2 жыл бұрын
Yes, you can find it at kzbin.info/aero/PLsjUcU8CQXGFFAhJI6qTA8owv3z9jBbpd
@jbhargav71812 жыл бұрын
@@QAFox Tq so much sir this is very useful to me and your explaining like taking example it was very easy to understanding us
@QAFox2 жыл бұрын
@@jbhargav7181 Welcome :)
@jbhargav71812 жыл бұрын
Sir we have class about logical and physical components in SQL