SQL Intermediate Certification on Hacker rank || Find the List of Products which were not Sold ?

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ต.ค. 2024
  • How to Earn SQL (Advanced) Certification on Hackerank ?
    In this video, you'll learn how to earn free certification from Hackerrank
    *********************Important Links ***********************
    1. SQL Basic Certification: • SQL Basic Skill Certif...
    2. SQL Intermediate Certification: • How to Write #SQL #Int...
    ************************************************************************
    ☎️ LET'S CONNECT!
    ************************************************************************
    ➥ Facebook: / kumarviveknitjsreee
    ➥ Linkedin : / vivek-kumar-32b16a191

ความคิดเห็น • 1

  • @13.AkashDas
    @13.AkashDas 3 หลายเดือนก่อน

    Hi Vivek, thanks for the solution but I have a question over here. Can it be solved using left join?
    select p.sku, p.product_name
    from product as p
    left join invoice_item as i on
    p.id=i.product_id
    where i.product_id is null
    order by p.sku asc