Bhushan Dhumane

CREATE TABLE ` Emp_Det ` ( `Emp_ID` int(11) default NULL, `Emp_name` varchar(100) default NULL, `Salary` decimal(18,3) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO ` Emp_Det ` (`Emp_ID`, `Emp_name`, `Salary`) VALUES (1, 'Prakash', 1000.000), (2, 'Praful', 1200.000), (3, 'Manish', 1100.000), (10, 'Nilesh', 900.000), (11, 'Chetan', 1200.000); 1) To find Second Max salary   SELECT   max (   Salary   )   FROM   Emp_Det WHERE   Salary   NOT   IN   ( SELECT   max (   Salary   )   FROM   Emp_Det ) O/p: max(Salary) 1100.000 2) To find Second Max salary with Description SELECT   * FROM   `Emp_Det` WHERE   Salary   NOT IN   ( SELECT   max (   Salary   ) FROM   `Emp_Det` ) ORDER   BY   salary   DESC LIMIT   1   ; OR SELECT   * FROM   Emp_det WHERE   Salary   =   ( SELECT   Max (   Sala...