2nd heighest Salary
CREATE TABLE IF NOT EXISTS `employee` (
`Eid` int(11) DEFAULT NULL,
`Name` varchar(10) DEFAULT NULL,
`Salary` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `Employee`
--
INSERT INTO `Employee` (`Eid`, `Name`, `Salary`) VALUES
(1, 'harry', '3500'),
(2, 'jack', '2500'),
(3, 'john', '2500'),
(4, 'xavier', '5500'),
(6, 'susana', '2400'),
(0, 'hgfgn', '3500'),
(8, 'hh', '3400'),
(9, 'hgfgn', '3500'),
(10, 'hh', '3500');
QUERY
SELECT *
FROM Employee
WHERE salary = (
SELECT Salary
FROM Employee
ORDER BY salary DESC
LIMIT 1 , 1 )
Output
| |
|
|
|
| 1 | harry | 3500 |
|
|
| 0 | hgfgn | 3500 |
|
|
| 9 | hgfgn | 3500 |
|
|
| 10 | hh | 3500 |
No comments:
Post a Comment