We have one tables tblSalary
empID empName empSal
1 A 5000
2 B 3000
3 C 2000
4 D 6000
Using of limit option we can find second highest salary in mysql.
select empSal from tblSalary order by empSal DESC Limit 1, 1
Output
5000
Introduction Git tags are an essential feature of version control systems, offering a simple way…
Introduction The methods that browsers employ to store data on a user's device are referred…
Introduction A well-known open-source VPN technology, OpenVPN provides strong protection for both people and businesses.…
Introduction Integrating Sentry into a Node.js, Express.js, and MongoDB backend project significantly enhances error tracking…
Introduction In the world of JavaScript development, efficiently managing asynchronous operations is essential. Asynchronous programming…
Introduction Let's Encrypt is a Certificate Authority (CA) that makes it simple to obtain and…