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

[@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 😊

[@KanchanChand-p9d]

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 😊

[@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

[@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

[@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

[@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

[@indergaming3053]

ankit bhai table b provide kar dia karo please

[@bidhanry9740]

Is join necessary, can we do it without join?

[@HimSha07]

can we do this without inner join?

[@SantanuPuhan]

nice

[@SACHINKUMAR-px8kq]

Thankyou Sir

[@abhishek_grd]

Great !

[@vigneshnagaraj7137]

How about the data?