Advanced SQL Full Tutorial | SQL Subqueries | Structured Query Language | Windows Function |

[@SCALER]

Take the Hunger test today. Click here: bit.ly/3Idu3QJ

[@osoriomatucurane9511]

Awesome, crtystal clear and concise. The best Window functions tutorial I have ever found.

[@SCALER]

Thank you so much! Super glad to hear that! 🙌🏼

[@optiongreeks_265]

Genuinely you taught the concepts in such a ways that the 1st year under graduate student can also understand very easily.....

[@wckd6726]

It's literally the best video for understanding window functions and sub queries

[@SCALER]

Happy to hear that! 🙌🏼

[@supa.scoopa]

Brilliantly explained!!

[@vaishalidhage-z9q]

Good explanation 👏🏻

[@sularaperera2719]

Best explanation ❤

[@harshadak6144]

Thanks for this video. Its really helpful ...!!!

[@SCALER]

Thanks! Glad this was helpful! 😃

[@dn9416]

Very useful

[@SCALER]

Happy to hear that! 🙌🏼

[@priyanka1311]

Thankyou

[@osoriomatucurane9511]

Sir, sorry I am not clear when to choose between running a query with join and using subquery when the result set comes from two tables, like retrieving employment details (empid, name, dept, salary) given the condition or criteria selection is department_name = XXXX?

[@niyatishah9020]

Is it possible to access the "HR" database?

[@wonderfulvamsi]

Why do we need Window functions? When I can simply left join the original table and the aggregated table (using group by) to achieve the same result?

[@vighneshjha4612]

bsdk bakchodi karni thi toh video pe kyun click kar rha hai , effort daal ke bhai ne video banayi hai appreciate karle

[@GR-gk8dh]

TODO