Nested queries or sub queries in SQL || SQL IN TELUGU

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

КОМЕНТАРІ • 83

  • @venkateshavula7466
    @venkateshavula7466 2 роки тому +2

    Wow nice explanation mam even our teacher doesn't teach properly but you teach everything is clearly and neatly presention on the laptop 👏👏👏👍👍👍👌👌👌👌👌

  • @leelabhavani7265
    @leelabhavani7265 3 роки тому +14

    I have full confusion on this topic...but ur step by step approch makes me to understand very easy..tq so much mam

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

    Explanation vere level mam thank you

  • @annimallanagesh5148
    @annimallanagesh5148 3 роки тому +4

    Thank you madam please take more classes ,ur explanation awesome👏👍

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

    Really you are all rounder mam... Simply awsome

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

    Explained very well and able to understand very easily. Thank you so much..

  • @venkyvenky2219
    @venkyvenky2219 2 роки тому +3

    mam chala baga cheparu naku ardham aindhi tq mam

  • @dailydeals4032
    @dailydeals4032 2 роки тому +2

    Very easily understanding classes

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

    Good query very informative

  • @vineethreddyvineethreddy3940

    Madam meru super madam super explanation are so much useful madam

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

    Thankyou mam good explanation use fully video's

  • @RamRam-ce2yk
    @RamRam-ce2yk 3 роки тому +2

    Thank q so much..
    Really ur videos helping a lot mam

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

    It helped get rid of the confusion....thank u mam🖤

  • @aishwaryab4906
    @aishwaryab4906 3 роки тому +2

    very well explained mam

  • @-MVineeth
    @-MVineeth 2 роки тому

    Excellent explanation mam

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

    Thank you medam..
    Now i am prepared to this quary

  • @b.roymiller2580
    @b.roymiller2580 Рік тому +1

    Well, understand madam.

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

    Good explanation mam

  • @Bharathkumar-tj7cr
    @Bharathkumar-tj7cr 2 роки тому +1

    tq madam good class

  • @pkittuerriswamy8239
    @pkittuerriswamy8239 3 роки тому +2

    Thank you madam and Generation of programming language (or) language and it's types and please explain cheyandi madam

  • @mojjadaprasad1368
    @mojjadaprasad1368 3 роки тому +1

    good explain, ma'ma

  • @memsofgamers9479
    @memsofgamers9479 3 роки тому +1

    Super mam keep doing

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

    Good explanation mam..🙏

  • @btechveeru749
    @btechveeru749 4 роки тому +3

    Thank you madam

  • @saisantoshkumar5034
    @saisantoshkumar5034 3 роки тому +2

    madam question kuda post cheyandi meeru teach chesetapudu

  • @manikhantayema2395
    @manikhantayema2395 3 роки тому

    Tq madam nice explanation

  • @panduvadisa670
    @panduvadisa670 2 роки тому +2

    Thank you so much mam

  • @_Ishwath
    @_Ishwath 8 місяців тому +1

    Thanks madam

  • @himabindu8038
    @himabindu8038 3 роки тому +1

    thank you so much mam...

  • @kuppilaadiseshusrinivas8292
    @kuppilaadiseshusrinivas8292 3 роки тому +1

    Adorable😊 mam

  • @ranatejs.r7896
    @ranatejs.r7896 4 місяці тому +1

    2nd highest salary why not offset 2 mam

  • @sureshbommisetty5501
    @sureshbommisetty5501 3 роки тому +2

    thanks a lot mam @lab mug

  • @laxmimuttennavar3872
    @laxmimuttennavar3872 3 роки тому +1

    Thank you Mam your explanation is great but can you teach in english mam plz

    • @Lab_Mug
      @Lab_Mug  3 роки тому +3

      Lot of people asking in telugu so i am starting in telugu.... After some time definitely i will start in english..... In my sub channel

    • @laxmimuttennavar3872
      @laxmimuttennavar3872 3 роки тому

      @@Lab_Mug thank you mam

    • @kallasuribabu3873
      @kallasuribabu3873 3 роки тому

      @@Lab_Mug TQ ku mam for telling in telugu.

    • @chandraobulareddyankireddy5829
      @chandraobulareddyankireddy5829 3 роки тому

      Select B.* from
      (SELECT ROWNUM as rn, a.*

      FROM
      (
      SELECT
      e.*
      FROM
      employees e
      ORDER BY
      e.salary DESC
      ) a)b
      WHERE
      b.rn Between 2 and 100;
      one or more records finds query
      where b.rn in (1,5)

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

    🙋

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

    tq

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

    Mam ippudu example 4th or 5th salary get cheyyali antey ela
    Limit & order by DESC use cheyyali ha?

  • @1f-60.c.drenuka8
    @1f-60.c.drenuka8 3 роки тому

    Thank u mam

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

    Madam how to find the maximum sal..what is condition..like where sal>

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

      Select max(sal) from emp

  • @eswar6311
    @eswar6311 3 роки тому

    Hi madam i completed my all sql playlist
    Please do video on Oracle DB 12C

  • @programmer649
    @programmer649 3 роки тому +1

    madam video volume improve cheyyandi madam

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

    Nth highest salary query please explain

  • @Rayachotyvenkat
    @Rayachotyvenkat 3 роки тому

    If I want 20th highest salary, not able to write lenght query right. Can you explain single sub query please

    • @alaparthisneha2455
      @alaparthisneha2455 3 роки тому +1

      you can using limit and offset together instead of subqueries ,to get nth salary also

  • @manjutharak
    @manjutharak 3 роки тому

    Hi Sister make video on debbuging in SQL Developer

    • @Lab_Mug
      @Lab_Mug  3 роки тому

      Will try tharak

  • @KDivya-mm4go
    @KDivya-mm4go 2 місяці тому

    Mam can i write this topic in dbms plz reply mamm

  • @guntreddisujithnaidu5040
    @guntreddisujithnaidu5040 9 місяців тому

    i have a question why wouldn't you use order by desc and limit and offset to get 2nd highest salary?
    please give me answer ?why?i mean explantation

    • @Lab_Mug
      @Lab_Mug  9 місяців тому +1

      Different logics gives same answer

  • @babarsk8784
    @babarsk8784 4 місяці тому

    Madam exam lo table vesi explain cheyala or miru rasinnattu rayala

    • @Lab_Mug
      @Lab_Mug  4 місяці тому

      Ela ayina parvaledu but table veste Little bit expressive... Based on ur time

    • @babarsk8784
      @babarsk8784 4 місяці тому +1

      @@Lab_Mug thanks for replying madam 🙏

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

    3rd highest salary cheppandi

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

    Plz send oracle 11g installation mam

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

      ua-cam.com/video/mTF8X5gpNUg/v-deo.html

  • @rohithmadipalli3495
    @rohithmadipalli3495 3 роки тому

    mam how to get third highest salary

  • @karrasriharshavardhini9709
    @karrasriharshavardhini9709 3 роки тому

    Mam normalization and normal form's explain mam

    • @Lab_Mug
      @Lab_Mug  3 роки тому

      DBMS: ua-cam.com/play/PLJSrGkRNEDAh34cvVArHe4ZM1B1VpSFK_.html

    • @Lab_Mug
      @Lab_Mug  3 роки тому

      Check in end of playlist

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

    Madam pleas first explain syntax then example 😢

  • @abhilashreddy3688
    @abhilashreddy3688 3 роки тому

    how to find nth highest salary

  • @swathilagisettytalks3346
    @swathilagisettytalks3346 3 роки тому

    Embedded sql video cheyalada mam dbms lo

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

    What is your language 🤔🤨😑

  • @keerthisurya9708
    @keerthisurya9708 4 роки тому +2

    Pls tell about normalization in DBMS mam

  • @chandraobulareddyankireddy5829
    @chandraobulareddyankireddy5829 3 роки тому

    Select B.* from
    (SELECT ROWNUM as rn, a.*

    FROM
    (
    SELECT
    e.*
    FROM
    employees e
    ORDER BY
    e.salary DESC
    ) a)b
    WHERE
    b.rn Between 2 and 100;
    one or more records finds query
    where b.rn in (1,5)

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

    Anno UA-cam channels choosa madam Anni waste anipinchoy. mee explanation naalo sarikota uttejanni nimpindi madam

  • @harshavardhanpenagaluru7771
    @harshavardhanpenagaluru7771 3 роки тому +1

    Thank you madam

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

    Anno UA-cam channels choosa madam Anni waste anipinchoy. mee explanation naalo sarikota uttejanni nimpindi madam