SQL Nested Queries in EXISTS, IN, FROM, SELECT. SQL Practice
https://www.w3schools.com/sql/trysql.... SQL Trainer
Nested queries offer a new level of flexibility after group by. This video covers nested queries in EXISTS, IN, and FROM clauses, as well as in SELECT positions.
Knowing all the capabilities of nested queries will earn you points in interviews and establish you as a highly trained specialist.
In this video, I'll show you how to build a very large and complex SQL query. If you understand it, you'll be able to do everything in SQL and even complete this homework assignment.
Take the homework seriously; I welcome your comments under the video.
---- Social Media
Telegram, where you can find out about new videos and receive additional content.
https://t.me/webDevGromMaxChannel
P.S. I respond faster on YouTube than on Telegram. I welcome comments on YouTube.
----
To support the channel
1) You can like the video (or dislike it if you didn't like it)
2) Leave a comment longer than 5 words (you can also leave a solved homework assignment)
3) Watch the video to the end (this will increase retention and help me with promotion)
4) Leave feedback in the comments about what could be improved in the video so you don't want to close it.
#sql #grommax
You can support the channel financially in the following ways:
1) Transfer to a card: https://send.monobank.ua/7oqmsFg3Y
2) Take the survey to help choose the right support options
https://forms.gle/ZbFCKJSpDNYp4AMC6
Table of Contents
00:00 - Introduction
00:18 - Nested Query in SQL
00:43 - EXISTS in SQL
01:59 - Nested IN query
03:13 - Nested query in FROM
06:16 - Nested query in SELECT
15:10 - Homework
On this page of the site you can watch the video online SQL Nested Queries in EXISTS, IN, FROM, SELECT. SQL Practice with a duration of hours minute second in good quality, which was uploaded by the user Максим Гром 02 October 2021, share the link with friends and acquaintances, this video has already been watched 9,214 times on youtube and it was liked by 232 viewers. Enjoy your viewing!
