Senior Software Interview Questions

75,528 senior software interview questions shared by candidates

/* Write a query to find all duplicate jobs in the People table */ select count(*) from People p1 join People p2 on p1.Job = p2.job and p1.FirstName <> p2.FirstName; /* Write a query to find all duplicate FirstName, and Job values in the People table and number of duplicates */ with cte as( select row_number() over(order by FirstName, job) as num, FirstName, job from People ) select count(*) from cte p1 join cte p2 on p1.Job = p2.job and p1.FirstName = p2.FirstName and p1.num <> p2.num; /* Write a query to find all duplicate First Names with different jobs in the People table */ select p1.FirstName from People p1 join People p2 on p1.Job < p2.job and p1.FirstName = p2.FirstName;
avatar

Senior Software Engineer

Interviewed at WideOrbit

3.6
Nov 18, 2020

/* Write a query to find all duplicate jobs in the People table */ select count(*) from People p1 join People p2 on p1.Job = p2.job and p1.FirstName <> p2.FirstName; /* Write a query to find all duplicate FirstName, and Job values in the People table and number of duplicates */ with cte as( select row_number() over(order by FirstName, job) as num, FirstName, job from People ) select count(*) from cte p1 join cte p2 on p1.Job = p2.job and p1.FirstName = p2.FirstName and p1.num <> p2.num; /* Write a query to find all duplicate First Names with different jobs in the People table */ select p1.FirstName from People p1 join People p2 on p1.Job < p2.job and p1.FirstName = p2.FirstName;

Summing up the individual digits for each number from 0 to k (0&lt;=k&lt;=10000000), return how many times the most common sum occurs. Examples: k=10 gives 2 (since 1 and 10 both sum up to 1) k=50 gives 6 (since 5, 14, 23, 32, 41, 50 all sum up to 5) k=7777 gives 555
avatar

Senior Software Engineer

Interviewed at Medallia

3.1
Jun 9, 2011

Summing up the individual digits for each number from 0 to k (0&lt;=k&lt;=10000000), return how many times the most common sum occurs. Examples: k=10 gives 2 (since 1 and 10 both sum up to 1) k=50 gives 6 (since 5, 14, 23, 32, 41, 50 all sum up to 5) k=7777 gives 555

Viewing 421 - 430 interview questions

Glassdoor has 75,528 interview questions and reports from Senior software interviews. Prepare for your interview. Get hired. Love your job.