How should I practice Second-Highest Distinct Salary?

Start by reading the full statement, solve the visible examples, then compare the pattern against related Chubb phone screen problems in FastPrep.

Is Second-Highest Distinct Salary associated with Chubb?

FastPrep tags this as a Chubb phone screen coding practice problem when the problem catalog has that company and stage context.

Second-Highest Distinct Salary

Chubb● EasyNEW GRADPHONE SCREEN

Problem statement

The employees table contains one row per employee with an optional salary.

Return exactly one row and one column named second_highest_salary. Its value is the second-highest distinct non-NULL salary. If fewer than two distinct non-NULL salaries exist, return NULL.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

employees

One row per employee.

Column	Type	Nullable	Description
employee_idPK	Integer	No	—
salary	Integer	Yes	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
second_highest_salary	Integer	Yes	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

employee_id is a unique integer.
salary is an integer or NULL.
Duplicate salary values share the same rank.
The result always contains exactly one row.