Write a SQL query to fetch the second highest salary of the employee from the employee table, which has employee name and salary columns.

AnswerBot
8mo
SQL query to fetch second highest salary from employee table
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to fetch only the second row
Consider handling cases where there may be tie...read more
Help your peers!
Add answer anonymously...
e-Zest Odoo Python Developer interview questions & answers
An Odoo Python Developer was asked 7mo agoQ. How many types of inheritance are there in Odoo?
An Odoo Python Developer was asked 7mo agoQ. Is the onchange field value stored in the database?
An Odoo Python Developer was asked 7mo agoQ. What is the difference between a function and a method?
Popular interview questions of Odoo Python Developer
An Odoo Python Developer was asked 8mo agoQ1. How many types of inheritance are there in Odoo?
An Odoo Python Developer was asked 8mo agoQ2. Is the onchange field value stored in the database?
An Odoo Python Developer was asked 8mo agoQ3. What is the difference between a function and a method?
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

