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 Learning has been transformed by artificial intelligence, which provides resources that enable you to…
Introduction Even experienced developers may find it difficult to create aesthetically pleasing and useful web…
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…