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

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 22

  • @harshalpatil6535
    @harshalpatil6535 Рік тому +5

    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.

  • @KanchanChand-p9d
    @KanchanChand-p9d Рік тому +1

    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.

  • @skblabla
    @skblabla Рік тому +2

    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
      @iffipifi1 6 місяців тому +1

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

  • @kartikkasat
    @kartikkasat 2 роки тому

    Much awaited video..thanks!

  • @HimSha07
    @HimSha07 Рік тому

    can we do this without inner join?

  • @kneelakanta8137
    @kneelakanta8137 Рік тому +1

    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
      @ankitbansal6  Рік тому +2

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

  • @bidhanry9740
    @bidhanry9740 8 місяців тому

    Is join necessary, can we do it without join?

  • @hasanmougharbel8030
    @hasanmougharbel8030 2 роки тому +1

    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
      @ankitbansal6  2 роки тому +1

      Ctes are just subquery . Cursor is completely different concepts.

    • @hasanmougharbel8030
      @hasanmougharbel8030 2 роки тому

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

  • @vigneshnagaraj7137
    @vigneshnagaraj7137 2 роки тому +1

    How about the data?

  • @varunl6948
    @varunl6948 Рік тому

    Thanks for this!

  • @ritudahiya6223
    @ritudahiya6223 Рік тому +1

    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

  • @indergaming3053
    @indergaming3053 Рік тому +1

    ankit bhai table b provide kar dia karo please

  • @SACHINKUMAR-px8kq
    @SACHINKUMAR-px8kq Рік тому

    Thankyou Sir

  • @abhishek_grd
    @abhishek_grd 2 роки тому

    Great !

  • @SantanuPuhan
    @SantanuPuhan 10 місяців тому

    nice