Mysql

---

With Limit
     SELECT salary FROM employee GROUP BY salary ORDER BY 
         salary DESC LIMIT 1,1;
With out Limit
     SELECT MAX(salary) FROM Employee WHERE Salary NOT IN
              ( SELECT Max(Salary) FROM Employee);                                    

< First Having,Replace,union, clause in Mysql >

Ask a question

• Question:

  {{questionlistdata.blog_question_description}}

  • Answer:

    {{answer.blog_answer_description  }}

  Replay to Question
  
  

(+91)-9910699802

Become A Member     Become A Teacher