Learn Oracle SQL : The Hierarchical Query Clause

[@adarshsrivastava4805]

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

[@Cadlg_Oracle_SQL]

I'm glad it was helpful, my friend. Hopefully, I will find some time to make more videos ;)

[@JoseAlvarez-dl3hm]

Awesome, I finally got what is the use for hierarchical queries, thanks a lot.

[@AwarapanBihu]

Simple and straight to the core. Incredible job !

[@Cadlg_Oracle_SQL]

Thanks!

[@backyardwilderness6928]

Thank you for such a simple method of explaining the concepts.. Thanks again!

[@luisontwo]

Really good stuff. Well explained.

[@Cadlg_Oracle_SQL]

Thanks, Luis!

[@parmarpooja007]

Beautifully explained...👍👍👍👍👍👍👍👍👍👍

[@sravannayini4329]

Thanks for explaining.Its super simple.Please make more videos.

[@Cadlg_Oracle_SQL]

You're welcome, my friend. Hope to find some time to make more videos ;)

[@musandlala7991]

Brilliant explaination

[@Cadlg_Oracle_SQL]

Thanks, Kmn!

[@pankajkharade6936]

superb explanation 👍👍👍

[@Cadlg_Oracle_SQL]

Thanks, Pankaj!

[@shilpananda4192]

Nice explanation.

[@debottamguha1344]

Nice and clear example

[@esakkijeyaraman2859]

Great explanation. !!!

[@Cadlg_Oracle_SQL]

Thanks, Esakki!

[@kevinsantana876]

nice example, making something complex simple

[@suriebc6779]

its a nice explanation.

[@Cadlg_Oracle_SQL]

Thanks, my friend.

[@kirankumar-jw3xi]

Could you please tell us the answer for the above question

[@phuongnamnguyen9856]

Can you help me with sql server I want to result like there Top level. Under level1 Top level. Under level 2 Top level. ....

[@thomasutube1]

Good.

[@ChatkareChapri]

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

[@ChatkareChapri]

Reply

[@Asdhjkqweyui]

super! make more videos!

[@Cadlg_Oracle_SQL]

Thanks! I will ;)