Duplicate Job Listings — LinkedIn Asked SQL Question

Solving SQL Question asked by LinkedIn Using Windowing

Originally Published in https://asyncq.com/

Photo by Caspar Camille Rubin on Unsplash

Introduction

• In this article we will solve Duplicate Job Listing SQL question which is asked by LinkedIn as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been provided with input table job_listings that contains job post by each company.
• But some companies posted duplicate listing.
• Our job is to find out how many companies made that mistake.

Input:

Output:

• In input table we can see , job id 945 and job id 164 has same description and title and posted by same company , hence our output count is 1.