Monday, January 3, 2011

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