#sql

[@richajain7793]

Good explanation, easy to understand

[@dailylifeofadataengineer7742]

Thank You Richa

[@shuchisahay7446]

Nice explanations

[@dailylifeofadataengineer7742]

Thank You

[@anuragkumar-ti1vz]

Ankit, could you explain when we are applying Left join with AND condition why AND part will be executed first. As per my understanding, join conditions will be executed from top to bottom. please explain

[@dailylifeofadataengineer7742]

Hi Anurag, Join condition will execute top to bottom but when we have AND clause then condition with AND clause will execute first, thats how SQL query works. If you still have doubts, let's connect on linkedin to discuss more this www.linkedin.com/in/ankit-shrivastava-5262561a/

[@pravin2139]

hi Ankit. I'm still confused on left join & and.. what I understood is , ....(emp where emp.salary = 1000) left join dept on emp.dept_id = dept.dept_id.. i.e., partial / subset of emp (i.e left) table joining with entire dept (i.e right) table... is this the case? if s, I'm confused with the result set.

[@dailylifeofadataengineer7742]

Hi Pravin, Lets connect on linkedin to discuss more this www.linkedin.com/in/ankit-shrivastava-5262561a/

[@sundarrajan211]

Keep support guys

[@dailylifeofadataengineer7742]

Thank You Sundar

[@ashishkumarwankhede9692]

Which SQL query is faster? Filter on Join criteria or Where clause? Please give the ans of above question.

[@doctoryoy4447]

Why do you keep asking "OK?" and "Right?" like nobody is there to answer you buddy, you are having a delusion