HomeНаука и техникаRelated VideosMore From: Oracle SQL

Learn Oracle SQL : The Hierarchical Query Clause

144 ratings | 11676 views
http://bit.ly/oracle-sql-course | Get the complete course today. Learn Oracle SQL : The Hierarchical Query Clause: In this video, I show you how to use the Hierarchical Query Clause in Oracle SQL to build a basic hierarchical query. This is an excerpt of the course "The Ultimate Oracle SQL Course" which you can get at a heavily discounted price here: http://bit.ly/oracle-sql-course ================ You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Html code for embedding videos on your blog
Text Comments (15)
Threelly AI (1 month ago)
Youtube comments are full of amusements sometimes.... https://chrome.google.com/webstore/detail/threelly-ai-for-youtube/dfohlnjmjiipcppekkbhbabjbnikkibo
Threelly AI (1 month ago)
My CAT Decided What I ATE for 24 HOURS (And This Is What Happended...) https://chrome.google.com/webstore/detail/threelly-ai-for-youtube/dfohlnjmjiipcppekkbhbabjbnikkibo
Let's Talk (10 months ago)
Please help me to solve below query . I used is to find duplicates . This is working fine SELECT distinct a.* FROM   HR.emp1 a where exists(select count(*) from   (SELECT b.* FROM HR.emp1 b WHERE b.rowid = a.rowid     INTERSECT     SELECT c.* FROM HR.emp1 c WHERE c.rowid <> a.rowid )); But when I used it inside below query it is not identifying the rowid ,I tried it by using alais too but without success . SELECT distinct a.* FROM   HR.emp1 a where 1 = (select count(*) from (select count(*) from   (SELECT b.* FROM HR.emp1 b WHERE b.rowid = a.rowid     INTERSECT     SELECT c.* FROM HR.emp1 c WHERE c.rowid <> a.rowid ))); Please help me to resolve the query
Let's Talk (10 months ago)
Reply
Kevin Santana (11 months ago)
nice example, making something complex simple
Awàrapán Bißhû (1 year ago)
Simple and straight to the core. Incredible job !
Oracle SQL (11 months ago)
Thanks!
Adarsh Srivastava (1 year ago)
Literally superb man..hats off to u .You just cleared by all doubt which I had before watching this video...You explained it as simple as it could be explain...waiting for the other tutorials of Hierarchical queries...Good job bro...keep doing this
Oracle SQL (1 year ago)
I'm glad it was helpful, my friend. Hopefully, I will find some time to make more videos ;)
Sravan Nayini (1 year ago)
Thanks for explaining.Its super simple.Please make more videos.
Oracle SQL (1 year ago)
You're welcome, my friend. Hope to find some time to make more videos ;)
super! make more videos!
Oracle SQL (1 year ago)
Thanks! I will ;)
surie bc (1 year ago)
its a nice explanation.
Oracle SQL (1 year ago)
Thanks, my friend.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.