0176. Second Highest Salary
Description
+-------------+------+
| Column Name | Type |
+-------------+------+
| Id | int |
| Salary | int |
+-------------+------+
Id is the primary key column for this table.
Each row of this table contains information about the salary of an employee.**Input:**
Employee table:
+----+--------+
| Id | Salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
**Output:**
+---------------------+
| SecondHighestSalary |
+---------------------+
| 200 |
+---------------------+ac
Last updated