SQL | Cross Apply | When to Use | Difference between Cross Apply and Inner Join
HTML-код
- Опубликовано: 25 июл 2024
- How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Beginners to Python Programming
skillshare.eqcm.net/GjMakm
Data Science and Business Analytics with Python
skillshare.eqcm.net/JrM1Aq
IBM Data Science Professional Certificate
imp.i384100.net/LPQvg3
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Python for Everybody Specialization
imp.i384100.net/DVz7Aj
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Coursera Plus - Data Science Career Skills
imp.i384100.net/c/3299742/132...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - learn@knowstar.org
Fantastic as usual! I like it when you show several use cases to demonstrate its use and the comparisons to show in what way it differs from an inner join. Thank you! I'm a fan! Haha.
Thank you very much!
You are so awesome! Thank you for the video!
Thank you
You were just magical!!!❤❤❤
Hope it was helpful!
very good example, way of teaching is superb madam
Glad it helped
Thank you ma'am
Thank You.
Sister can u plz tell me which join is fast inner join or cross join when we know I'd on both table are same.
Great video. How to boldify the result output?
Thank you. You can Go to Tools -> Options -> Fonts and Colors . Select Grid Results and you can change the font, size, color etc.
Thanks for sharing. Question. Is there a way to replace the outer apply operator with a join clause when transferring a query from sql server to HIVE. Because to my knowledge hive does not support apply operators or table values functions.
Thank you. Yes, Hive has very limited SQL features. Most of the times, an Apply query can be converted to JOIN conditions using Aggregate functions or CTEs or subqueries.
@@LearnatKnowstar thank you for the reply. I will definitely look more into this method.
11:26 you didn’t passed dept id 2 in the function. Then why did we get data only for dept id =2? Does it mean that in all departments only one was hired in last 2 weeks?
Yes, the data was such in the table. If there would have been more matches in other dept ids, they would have been returned as well.
Not a very good explanation. Cross Apply is usually used in a join when there is a table on one side and a table function with arguments on the other. If you use an Inner Join, then the value of the table function is calculated before the execution of the inner join, after which the inner join of the table and the result of the calculation of the table function is performed.
In the case of Cross Apply, the value of the table function is calculated when it is executed for each row of the table. Cross Applay is a correlated internal join. Thus, it becomes possible to pass one or more values from the current row of the table as arguments to the table function. There is a serial connection of each row of the table with the results of the calculation of the table function with arguments from the current row of the table.
Thank you for your wonderful explanation. Will try to do a better job next time!
𝙸 𝚠𝚊𝚗𝚝 𝚝𝚘 𝚕𝚎𝚊𝚛𝚗 𝚜𝚚𝚕 𝚙𝚕𝚜 𝚑𝚎𝚕𝚙 𝚖𝚎 𝚠𝚒𝚝𝚑 𝚏𝚛𝚘𝚖 𝚜𝚌𝚊𝚛𝚝𝚑 𝚝𝚘 𝚍𝚎𝚟𝚎𝚕𝚘𝚙 𝚜𝚘𝚖𝚎 𝚋𝚊𝚜𝚒𝚌 𝚜𝚌𝚛𝚒𝚙𝚝𝚜