# SQL Query to find the Nth minimum Salary

Here, we will learn how to **find Nth minimum salary of an employee from given table in MySQL**?

Submitted by Preeti Jain, on January 02, 2018

**Given a table ‘EMPLOYEE’ and we have to find Nth minimum salary of an employee.**

**TABLE: EMPLOYEE**

ID NAME CONTACT SALARY1 PREETI 123456 2000 2 ARPIT 123789 3000 3 ADI 147258 5000 4 APOORV 789632 10000 5 RIDDHI 148796 20000 6 REX 148965 30000 7 WENDY 128659 40000 8 ANIKET 123489 50000

**Case 1: Write a query to find first minimum salary employee from Employee. **

mysql> select * from EMPLOYEE where salary = (select min(salary) from EMPLOYEE);

**Output/Result**

ID NAME CONTACT SALARY 1 PREETI 123456 2000

**Case 2: Write a query to find second minimum salary employee from Employee.**

mysql> select * from EMPLOYEE where salary = (select min(salary) from EMPLOYEE where salary > (select min(salary) from EMPLOYEE));

**Output/Result**

ID NAME CONTACT SALARY 2 ARPIT 123789 3000

**Case 3: Write a query to find third minimum salary employee from Employee.**

mysql> select * from EMPLOYEE where salary = (select min(salary) from EMPLOYEE where salary > (select min(salary) from EMPLOYEE where salary > select(min(salary) from EMPLOYEE)));

**Output/Result**

ID NAME CONTACT SALARY 3 ADI 147258 5000

**Case 4: Write a query to find fourth minimum salary employee from Employee. **

mysql> select * from EMPLOYEE where salary = (select min(salary) from EMPLOYEE where salary > (select min(salary) from EMPLOYEE where salary > (select(min(salary) from EMPLOYEE where salary>(select min(salary) from EMPLOYEE))));

TOP Interview Coding Problems/Challenges

- Run-length encoding (find/print frequency of letters in a string)
- Sort an array of 0's, 1's and 2's in linear time complexity
- Checking Anagrams (check whether two string is anagrams or not)
- Relative sorting algorithm
- Finding subarray with given sum
- Find the level in a binary tree with given sum K
- Check whether a Binary Tree is BST (Binary Search Tree) or not
- 1[0]1 Pattern Count
- Capitalize first and last letter of each word in a line
- Print vertical sum of a binary tree
- Print Boundary Sum of a Binary Tree
- Reverse a single linked list
- Greedy Strategy to solve major algorithm problems
- Job sequencing problem
- Root to leaf Path Sum
- Exit Point in a Matrix
- Find length of loop in a linked list
- Toppers of Class
- Print All Nodes that don't have Sibling
- Transform to Sum Tree
- Shortest Source to Destination Path

Comments and Discussions

**Ad:**
Are you a blogger? Join our Blogging forum.