What is the Order Of Execution of an SQL Query | Oracle Shooter

Excellent 👌

Thanks Sir

How top make query execution faster
It executed after select..

Superb job 👍

great video sir

Loved the video sir ❤️

Vary good 👍

could you make a video on rownum with order by clause combination ??

Thanks for sharing info

what about query who have sub-query ?

very helpful thank You

cool one . helpful

hi sir I was trying to excute this query . before adding the rank condition it is excuting fine. but after adding the rank over partition the code is not working. Can you please help me here.

select "DV - Partner 360"."Partner"."Partner Name", "DV - Partner 360"."Partner"."Partner Number", "DV - Partner 360"."Program"."Program Name", "DV - Partner 360"."Program"."Program Type", "DV - Partner 360"."Partner Enrollments"."Processing Status", case when "DV - Partner 360"."Partner Enrollments"."Processing Status" = 'Approved' then 1 when "DV - Partner 360"."Partner Enrollments"."Processing Status" = 'Pre-Approved' then 2 when "DV - Partner 360"."Partner Enrollments"."Processing Status" = 'Pending Approval' then 3 when "DV - Partner 360"."Partner Enrollments"."Processing Status" = '-' then 4 when "DV - Partner 360"."Partner Enrollments"."Processing Status" = 'Approved - Future Enrollment' then 5 when "DV - Partner 360"."Partner Enrollments"."Processing Status" = 'ReturntoPartner' then 6 else 7 end as priroty , rank() over(partition by "DV - Partner 360"."Partner"."Partner Number","DV - Partner 360"."Partner Enrollments"."Processing Status") race from "DV - Partner 360" where "DV - Partner 360"."Program"."Program Type" in ('MEMBER','TRACK') order by priroty asc, "DV - Partner 360"."Partner"."Partner Number", "DV - Partner 360"."Program"."Program Name";

What if top is present in select statement, will it execute with select statement or after order by?

Thank you very much, it's very helpful :)

Nice ! Thank you ! 🙏

Very helpful! 👍

Good explanation .. thanks sir

Thank you very much 😍

Very Helpful. Thank you.

After watching this video ,I could say my 50% doubts are solved ...Great job sir

If I written in where clause that
1) sys_date =systate or
2) sys_date='02-may-2020 which is the fastest method

you are so inteligent man

very perfect knowladge

Great work sir!!!! Appreciate that

thank you.

you are going great job Keep it up, Nicely explain complete concept