Junior Software Developer Interview Questions

4,371 junior software developer interview questions shared by candidates

Say we had a table of Patients in a relational database. There is a column with first names which doesn't contain unique values. Which SQL query would you use to count how many unique names are in there? What would the command look like? What about to find the number of people that have the same name as you? Also, how would you output the frequency for each name?
avatar

Junior Software Developer

Interviewed at DoctorCare

3.7
Jul 14, 2020

Say we had a table of Patients in a relational database. There is a column with first names which doesn't contain unique values. Which SQL query would you use to count how many unique names are in there? What would the command look like? What about to find the number of people that have the same name as you? Also, how would you output the frequency for each name?

Viewing 2281 - 2290 interview questions

Glassdoor has 4,371 interview questions and reports from Junior software developer interviews. Prepare for your interview. Get hired. Love your job.