Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Asked 2mo ago|

Coforge

Coforge

Second Highest Employee Salary

Easy

SubqueriesRankingAggregations

Problem

Task

You are given an employees table from a Coforge workforce dataset. Write a PostgreSQL query to return the second highest distinct salary from the table. If the highest salary appears multiple times, it should still count only once. If there is no second distinct salary, the query should return no rows.

Problem

Task

You are given an employees table from a Coforge workforce dataset. Write a PostgreSQL query to return the second highest distinct salary from the table. If the highest salary appears multiple times, it should still count only once. If there is no second distinct salary, the query should return no rows.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Cobblestone Energy

Second Highest Trader SalaryEasy

Best Buy

Second Highest Salary at NovaTechEasy

McKinsey &

Top Departments by Average SalaryMedium

Second Highest Employee Salary | Dataford Interview Questions