FirstService Residential Interview Questions

FirstService Residential Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(22)
Machine Learning
(8)
SQL
(5)
Statistics
(5)
Data Modeling
(4)

FirstService Residential Interview Questions

Practice for the FirstService Residential interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
salary INTEGER
SQL
Easy
Probability
Hard
Loading pricing options

View all Firstservice residential questions

Challenge

Check your skills...
How prepared are you for working at Firstservice residential?

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion