SQL Tutorial #13 - SQL EXISTS and NOT EXISTS Operator
HTML-код
- Опубликовано: 7 май 2022
- Get all my courses for USD 5.99/Month - bit.ly/all-courses-subscription
In this SQL Tutorial, we will learn about SQL Exists and Not Exists Operators. EXISTS operator is used to test the existence of any record on SUBQUERY, if the SUBQUERY returns TRUE then the main query is evaluated.
👉 FULL PLAYLIST - SQL Tutorial: bit.ly/Sql-Tutorial
👉 More Training's at: training.rcvacademy.com
🌟 Please hit LIKE ❤️, SHARE, and SUBSCRIBE for more AMAZING
courses:
🔔 SUBSCRIBE to CHANNEL | Click the link to Subscribe: bit.ly/2YGU6JM
🌟 TEST AUTOMATION COURSES 🌟
👉 Selenium with Java: bit.ly/selenium-webdriver-tut...
👉 Selenium with Python: bit.ly/SeleniumPythonTutorial
👉 Robot Framework Automation: bit.ly/robot-framework-tutorial
👉 TestNG Tutorial: bit.ly/testng-tutorial
👉 PyTest Tutorial: bit.ly/PyTest-Tutorial
👉 Jenkins Tutorial: bit.ly/jenkins-tutorials
👉 Git and GitHub Tutorial: bit.ly/git-and-github-tutorial
👉 Python Logging Tutorial: bit.ly/python-logging-tutorial
👉 Selenium XPATH Tutorial: bit.ly/selenium-xpath-tutorial
👉 CSS Selectors Tutorial: bit.ly/css-selectors-tutorial
👉 JSONPath Tutorial: bit.ly/2sIZIFG
👉 Python Behave Tutorial: bit.ly/python-behave-tutorial
👉 Cucumber Selenium Tutorial: bit.ly/cucumber-selenium-tutorial
🌟 MANUAL TESTING AND ISTQB COURSES 🌟
👉 Manual Testing Full Course: bit.ly/SoftwareTestingTutorial
👉 ISTQB Agile Tester Course: bit.ly/istqb-agile-tester-cert...
👉 ISTQB Foundation Level Course: bit.ly/istqb-foundation-level-...
🌟 SOFTWARE TESTING MOCK INTERVIEWS 🌟
👉 bit.ly/software-testing-mock-...
🌟 SOFTWARE TESTING INTERVIEW QUESTIONS AND ANSWERS 🌟
👉 bit.ly/software-testing-inter...
🌟 RESUME AND CAREER TIPS 🌟
👉 Interview Prep Tips: bit.ly/interview-and-resume-tips
👉 Career Tips: bit.ly/software-testing-caree...
🌟 API TESTING COURSES 🌟
👉 SoapUI Tutorial: bit.ly/Sopui-tutorial
👉 Postman Tutorial: bit.ly/2PBbhI7
👉 Katalon API Testing: bit.ly/Katalon-API-Testing-Tu...
🌟 PROGRAMMING COURSES 🌟
👉 Java for Testers: bit.ly/2F1iL1B
👉 Python for testers: bit.ly/python-for-testers
👉 Python Basics: bit.ly/python-programming-tuto...
🌟 TEST MANAGEMENT TOOLS 🌟
👉 TestLink Tutorial: bit.ly/TestLink-Tutorial
👉 TestRail Tutorial: bit.ly/testrail-tutorial
👉 PractiTest Tutorial: bit.ly/practitest-tutorial
👉 TestLodge Tutorial: bit.ly/testlodge-tutorial
🌟 AGILE TESTING TOOLS 🌟
👉 Zephyr for Jira: bit.ly/zephyr-for-jira-tutorials
👉 Zephyr for Jira: bit.ly/learn-zephyr-for-jira
🌟 ATLASSIAN JIRA COURSES 🌟
👉 Jira Beginner Tutorial: bit.ly/jira-beginner-tutorial
👉 Jira Workflow Tutorial: bit.ly/2EzKOEB
👉 Jira Cloud Tutorial: bit.ly/Jira-Cloud-Tutorial-fo...
👉 Jira Administration Tutorial: bit.ly/36MPPFR
👉 Jira Intermediate Tutorial: bit.ly/Atlassian-JIRA-tutorials
👉 Jira Essentials Training: bit.ly/jira-tutorials
🌟 AGILE PROJECT MANAGEMENT COURSES 🌟
👉 Confluence Tutorial: bit.ly/Confluence-Tutorial
👉 Jira Work Management: bit.ly/jira-work-management
👉 Jira Roadmap Tutorial: bit.ly/jira-roadmaps-tutorial
🌟 AGILE BASICS COURSE 🌟
👉 Agile Tutorials: bit.ly/agile-tutorials
👉 All Playlists of SoftwareTestingMentor Channel: / softwaretestingmentor
👉 All Playlists of RCV Academy Channel: / @rcvacademy
🌟 FOLLOW US ON TWITTER 🌟
/ rcvacademy
/ swtmentor
/ mrmverma
🌟 LIKE US ON FACEBOOK 🌟
/ softwaretestingmentor
/ rcvacademy47
🌟 OUR TUTORIAL WEBSITES 🌟
www.softwaretestingmentor.com
www.rcvacademy.com
🌟 GET MY TRAININGS ON UDEMY 🌟
www.udemy.com/user/manish68/
✨ Tags ✨
sql exists and not exists operator,sql exists,sql not exists,where exists and not exists in sql?,not exists,sql tutorial,exists and not exists in sql,sql tutorial for beginners,what is if not exists in sql?,sql tutorial advanced,software testing mentor sql,sql course,sql tutorial youtube,exists operator in sql,not exists operator in sql
✨ Hashtags ✨
#SqlTutorial #SQL #SqlCourse #SqlBaiscs #MySQL #MySQLTutorial #LearnSql #RcvAcademy #SoftwareTestingMentor
🌟 Join this channel to support my work 🌟
/ @softwaretestingmentor
Beautifully Explained! Thank you
Hello, sir. In the first case (4:15) it really works as a true/false condition. No matter what is in the subquery, if it is true, then the main query is executed, and it returns all values from the table. While in the second case (6:46), the result of the main query is limited by the values that are returned by the subquery. Why is that? Please help me understand.
If output is true then it return all rows of first relation which is the first case in above video.....
If output is resultset then left side query output is filter with result of sub query...
Hope it solve your doubt
@@ravindravyasit123 In the first case also there is a result set(1 row) for the sub query but the main query is not limited by it.
please watch this video and your doubt will be cleared. It is related to how nested subquery and correlated subquery work. In the case of exists/not exists, first the outer query runs row by row and for every row of the outer query, the inner query has to run those many times (basically the subquery is not just executed once). ruclips.net/video/wA9GJZcB618/видео.html&ab_channel=GateSmashers
really helpful, clean explain and easy to understand!! thank you sir❤
Thanks lot it's very helpful
Can I have the sample database which you are using here in the example?
Excellent explanation sir
thanks for ur video
Amazing tutorial thank you so much it was helpful
Thanks you sir i can easily understand please do more vedioes
Thank you so much ❤
Could you please share with us the used database?
thank you so much. After 2 minutes of video I understood everything
Glad it helped! Keep watching and sharing.
Thanks Sir. You have made it really lucid.
Glad to hear that!
Keep watching for more videos and tutorials.
If I execute the last example subquery seperately we are not getting any values but with WHERE EXISTS we are getting values. Can you please Explain?
Useful 👍
Really well explained sir...thank you🎉
Glad you liked it! Keep watching and sharing.
very informative thanks explained greatly
Thank you very much. Keep watching and sharing.
do you use EXISTS only in a subquery or there are other use cases? thanks
I use it in Stored procedure
Hi sir,
The explanation overall is good.
But one doubt that I am not able to figure out yet, in which video did you create the Orders table and how is a primary column of table Employees linked with that of orders?
exactly
thank you
You're welcome
right...what right???
Haan sir, kr diya dislike and report.
One of the worst explanation I have seen on the topic. You just read the definition and did not show the step-by-step execution. Lean to teach.
I wish you could have little patience to wait and see the full video 😀, it contains demo as well, please have patience if you want to learn something. Anyways, thanks for your awesomeness and support without even watching the full video 😀