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

Learn Oracle SQL : The Hierarchical Query Clause

68 ratings | 5470 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 (13)
Let's Talk (2 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 (2 months ago)
Reply
Kevin Santana (3 months ago)
nice example, making something complex simple
Awàrapán Bißhû (4 months ago)
Simple and straight to the core. Incredible job !
Oracle SQL (3 months ago)
Thanks!
Adarsh Srivastava (4 months 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 (4 months ago)
I'm glad it was helpful, my friend. Hopefully, I will find some time to make more videos ;)
Sravan Nayini (4 months ago)
Thanks for explaining.Its super simple.Please make more videos.
Oracle SQL (4 months ago)
You're welcome, my friend. Hope to find some time to make more videos ;)
super! make more videos!
Oracle SQL (6 months ago)
Thanks! I will ;)
surie bc (7 months ago)
its a nice explanation.
Oracle SQL (7 months ago)
Thanks, my friend.

Would you like to comment?

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