find the Second Highest Salary of Employee in SQL

 SELECT MAX(salary) FROM employee WHERE salary NOT IN (SELECT MAX(salary) FROM employee);

======================================================================= 

                                                                    OR

=======================================================================
select salary from employee order by salary desc limit 1 offset 1 

===============================================================

Comments

Post a Comment

Popular posts from this blog

Mr. Myers wants to edit the marks assigned to the questions

Pyramid Examples Java Program for find duplicate element and increased duplicate element by 1   A mathematics question paper has certain number of questions and each question is assigned some random maximum marks Mr. Myers wants to edit the marks assigned to the questions such that.  (1) all questions in the paper should have distinct maximum marks. (2) the total marks of all the questions should be as low as possible. Mr. Myers wants to achieve this by making minimal changes in the original format, assigning the question at least so much marks as it originally had. find the minimum total marks that can set the paper for. ? All the inputs in array are minimum marks for a question and it can increase if the duplicates occurred  in the array. Example Input 3 2 4 4 Example Output 11 Explanation As two questions have the same marks, max marks for one of them needs to be incremented to 4.  He can set the paper with 2+4+4=11 marks. This progra...
Read more

Genral Ability

In a survey of 1000 fruit eaters who like to east one fruit among people, mango and grapes; 400 do not like grape, 380 do not like mango and 542 do not like apple, 294 like both mango and apple, 277 like both grape and mango and 120 like both grape and apple How many people like only grapes. a. 281 b. 107 c. 216 d. 207 e. 210 Check Answer 216
Read more

Object Orinted Programing

  OOP's  Theory Based Question & Answers 1.) Object : An Object is an instance variable of class. An Object is contain an references address. 2.) Class : A class is collection of methods and objects. 3.) Encapsulation : Wrapping of the data into single unit known as encapsulation. ex. class. 4.) Inheritance : Inheritance show relationship between two classes, main purposes of inheritance is code re-usability. There are three types of inheritance, Single, Multilevel, Hierarchical. 5.)  Polymorphism : One to many form is refers to polymorphism. There are two types of polymorphism         (i). Method Overloading : If a class have same methods, but different parameters known as method overloading.        (ii). Method Overloading : If a child class have same method as declared in the parent, known as the method overloading. 6.) Abstraction : Abstraction is a process of hiding implementation details and show...
Read more