IBM SQL Interview Question | Using CTEs

Опубликовано: 23 Март 2026
на канале: Nishtha Nagar

4,905

188

Learn how to find the details of employees having 3rd highest salary in each job_category. you

Script -
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
salary DECIMAL(10, 2),
job_category VARCHAR(10)
);
INSERT INTO employees (employee_id, first_name, last_name, salary, job_category) VALUES
(101, 'John', 'Doe', 50000, 'DEV'),
(102, 'Jane', 'Smith', 60000, 'DEV'),
(104, 'Charlie', 'Davis', 58000, 'DEV'),
(108, 'Ivan', 'Hall', 62000, 'DEV'),
(103, 'Alice', 'Johnson', 61000, 'HR'),
(105, 'Eve', 'Miller', 61000, 'HR'),
(107, 'Heidi', 'Clark', 57000, 'HR'),
(109, 'Judy', 'Lewis', 53000, 'HR'),
(110, 'Paul', 'Allen', 70000, 'FIN'),
(113, 'Olivia', 'Scott', 65000, 'FIN'),
(115, 'Nora', 'Adams', 72000, 'FIN'),
(106, 'Grace', 'Wilson', 66000, 'PDT'),
(111, 'Rose', 'Baker', 68000, 'PDT'),
(112, 'Max', 'Carter', 66000, 'PDT'),
(114, 'Lucas', 'Turner', 64000, 'PDT');

TIMESTAMP
00:00 Introduction
00:31 Problem Description
05:61 Solution Implementation

#sql #sqlinterview #sqlinterviewquestions