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