Top 50 Having Interview Questions
The most frequently asked Having questions across all roles and companies, ranked by real interview frequency. Updated daily.
Find duplicate customer profiles by grouping on identifying fields and returning only repeated records.
Adtalem Global Education
University of Southern California
Blue Cross Blue Shield of MichiganFind duplicate customer emails using GROUP BY and HAVING in PostgreSQL.
Guy Carpenter
Western Digital
BismartUse GROUP BY and HAVING to identify duplicated Grail assay sample identifiers and their record counts.
TransUnion
Acrisure
GrailUse GROUP BY and HAVING to find duplicate policy records in Ryan Specialty data.
Gramener
CarGurus
Fresh GravityUse JOIN, GROUP BY, and HAVING to find the top three departments by average salary with at least five employees.
Paylocity
McKinsey &
Booz Allen HamiltonUse GROUP BY and HAVING to find NetSuite customers with at least two approved sales orders.
Netsuite
Idexcel
Samsung ElectronicsUse GROUP BY and HAVING to find duplicate patient records in a Johns Hopkins Medicine dataset.
Emerson
CareDx
SberbankFind customer records with repeated non-empty email addresses, treating case and surrounding whitespace as insignificant.
Philips
PwCSign up to see every question
Create a free account to unlock this list and practice real interview questions.