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 In the world of web development, selecting the correct framework is critical. Laravel and…
Introduction By enabling containerization, Docker has transformed the way software is built, deployed, and managed.…
Introduction Speed and efficiency are critical in the ever-changing world of web development. Effective caching…
Introduction Git, a popular version control system in software development, enables developers to track changes,…
Introduction Are you tired of grappling with tangled changes and unfinished work while using Git?…
Introduction Version control is essential in software development because it ensures that changes to a…