How to Write SQL with CTE | SQL With Clause | Common Table Expression

In this video we will understand how to use SQL with clause also known as CTE or Common Table expression.
Playlist for complex SQL interview problems for product based companies:
• Complex SQL Questions ...

[@harshalpatil6535]

One thing i liked the most from you Ankit, You covers single topic in very less time. So it is easy to watch as well as understandable. Keep going mate.

[@ankitbansal6]

Glad to hear that 😊

[@user-or1qz1xe2f]

Just a suggestion you can move this video at top of the playist . I have been following your playist this is used quite a several time.

[@varunl6948]

Thanks for this!

[@kartikkasat]

Much awaited video..thanks!

[@ankitbansal6]

Hope it helps 😊

[@abhishek_grd]

Great !

[@SACHINKUMAR-px8kq]

Thankyou Sir

[@user-yl2ov2no6u]

nice

[@skblabla]

Hi Ankit, what is max(avg_sal)?, wont avg_sal be a single value for the table.
why do we need to find max(avg_sal) in that case?

[@iffipifi1]

He said it doesn't make sense, it's just to point out that you can make ctes with other ctes

[@bidhanry9740]

Is join necessary, can we do it without join?

[@ritudahiya6223]

Hi ankit.. Thank you so much for your efforts.. Can you please make more c
Videos on how to use cte and view in real world data like how we work in a company. It would be really helpful.. Waiting for your reply

[@ankitbansal6]

Noted

[@HimSha07]

can we do this without inner join?

[@vigneshnagaraj7137]

How about the data?

[@hasanmougharbel8030]

Hey there,
God bless your efforts.
I am new to sql language with a simple enquiry.
How are ctes different than a cursor?
Aren't they both considered as temporary result sets?
Thanks for taking care of this.

[@ankitbansal6]

Ctes are just subquery . Cursor is completely different concepts.

[@hasanmougharbel8030]

@@ankitbansal6 is there any main difference i can differentiate between both? Thanks for taking time on this

[@indergaming3053]

ankit bhai table b provide kar dia karo please

[@kneelakanta8137]

Can we create a table in database using the cte result, if yes, how?
I have faced this question in interview, pls share what we can say?

[@ankitbansal6]

Yes you just say create table tablename as
With cte ()
Select