Differences b/w Non-Correlated SQ and Correlated SQ in SQL | MSSQL Training | By Mr.Sudhakar L

Поделиться
HTML-код
  • Опубликовано: 4 авг 2024
  • ** For Online Training Registration: goo.gl/r6kJbB ? Call: +91-8179191999
    💡 Visit Our Website for Classroom Training:
    nareshit.in/sql-server-training/
    💡 For Online Training:
    nareshit.com/course/sql-serve...
    #sqlserver #server #programming #course #Tutorials #Training #Videos
    --------------------------
    💡 About NareshIT:
    "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
    --------------------------
    💡 Our Online Training Features:
    🎈 Training with Real-Time Experts
    🎈 Industry Specific Scenario’s
    🎈 Flexible Timings
    🎈 Soft Copy of Material
    🎈 Share Videos of each and every session.
    --------------------------
    💡 Please write back to us at
    📧 us.training@nareshit.com/ 📧 online@nareshit.com or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
    --------------------------
    💡 Check The Below Links
    ► For Course Reg: goo.gl/r6kJbB
    ► Subscribe to Our Channel: goo.gl/q9ozyG
    ► Circle us on G+: plus.google.com/+NareshIT
    ► Like us on Facebook: / nareshit
    ► Follow us on Twitter: / nareshitek
    ► Follow us on Linkedin: goo.gl/CRBZ5F
    ► Follow us on Instagram: goo.gl/3UXYK3

Комментарии • 35

  • @NareshIT
    @NareshIT  5 лет назад

    Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

  • @ahmedqamar1761
    @ahmedqamar1761 10 месяцев назад

    Sudhakar Sir if you are seeing this then i want to tell you that you are best teacher i have ever come across till now thank you so much for this playlist. i will always remember you in my prayer.

  • @jeyakrishnameetsu5168
    @jeyakrishnameetsu5168 4 года назад +1

    thank you u made me to come out from the SQL joints and SUBQUERY . now i got cleared :) thanks a lot sir for publishing these videoes

  • @zuherabud744
    @zuherabud744 6 лет назад +3

    Best teacher ever upload more explanation on correlated sq

  • @dreamvallyhasan4807
    @dreamvallyhasan4807 5 лет назад +1

    you are the best teacher ever....concept is clear like water :)...thanks a lot

  • @mdshaklain686
    @mdshaklain686 4 года назад +4

    CO RELATED PART WAS NOT
    EXPLAINED

  • @pratibha27100
    @pratibha27100 5 лет назад +1

    Thank you, nice explanation !

  • @BHARATGARANDE
    @BHARATGARANDE 6 лет назад

    Great .....Please be continue...

  • @mdb8511
    @mdb8511 3 года назад

    Excellent sir keep doing👍

  • @haceena
    @haceena 6 лет назад

    Good one!

  • @gateeasycse
    @gateeasycse 4 года назад

    Sub query also used to retrieve data from more than one table,can I say subquery and join are equally expressive power?

  • @stalinkuna
    @stalinkuna 3 года назад

    Very useful sir

  • @kirankumar-iz3tw
    @kirankumar-iz3tw 2 года назад

    excellent video..

  • @sravankumar1767
    @sravankumar1767 3 года назад +1

    nice explanation

  • @kritika_0204
    @kritika_0204 3 года назад

    Thankyouuu so much sir

  • @ajaykumarvelivela9472
    @ajaykumarvelivela9472 4 года назад

    Thanks bro

  • @murlikrishnadora2755
    @murlikrishnadora2755 6 лет назад +1

    Sir how to know which one is correlated or non correlated sub query plz explain

  • @harikrishnasai6104
    @harikrishnasai6104 2 года назад

    TnQ so much sir

  • @hieptrinh2308
    @hieptrinh2308 10 месяцев назад

    i don't understand the comparison to 0. Please break it down row for row on the outer query and row for row on the inner query. Thanks.

  • @abhay6276
    @abhay6276 2 года назад +1

    any one can tell why E2 table has been added in query whereas data having single table?

  • @bltpl84
    @bltpl84 5 лет назад

    what if Salary column is in a different table and u have to join 2 tables?

  • @mohanreddy8036
    @mohanreddy8036 6 лет назад

    hi sir will you please make a MSBI videos and upload it sir

  • @bandarurudraiah6078
    @bandarurudraiah6078 2 года назад

    when duplcate occur(two persons salary is same how to find)

  • @venkatareddykummitha5863
    @venkatareddykummitha5863 3 года назад

    Which alias name (e1 or e2) is first stored in memory

  • @maheshbhalekar6367
    @maheshbhalekar6367 6 лет назад

    please upload complex view video

  • @venkatareddykummitha5863
    @venkatareddykummitha5863 3 года назад

    Explain logic and comparision

  • @venkatareddykummitha5863
    @venkatareddykummitha5863 3 года назад

    Anyone can explain the logic e2.salary>e1.salary and comparing with zero

  • @arunrocketz
    @arunrocketz 4 года назад

    Awesome

  • @sairamnigidala3227
    @sairamnigidala3227 5 лет назад

    this is enough for mssql ,,,,,to learn ............ans plz

  • @levisminch5913
    @levisminch5913 2 года назад

    Co related was not explained properly

  • @harikrishnasai6104
    @harikrishnasai6104 2 года назад

    TnQ so much sir