Mysql

December 9, 2013

Get the second highest salary from employee table in mysql:

SELECT max(salary) as salary FROM employee WHERE salary < (SELECT max(salary) FROM employee)

admin

This Post is Uploaded by Admin

Share:

Share:

Related Posts

Database Management in WordPress: 9 Tips for Efficient Data Handling

31 React Best Practices for Writing Clean and Efficient Code

8 Most Popular Software Testing Methodologies

6 Benefits of Building a Dedicated Offshore Software Development Team for Your Business

Our Experience Developing Enterprise Application using Laravel and Vue.js

11 PHP Best Practices: Tips and Techniques for Writing Better Code

10 Tips to Manage an Outsourced Partner Effectively

The Role of Automation in Quality Assurance: Enhancing Efficiency and Accuracy

Building Powerful Single Page Applications with React: A Beginner’s Guide

Free CodeIgniter Tutorial