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