write query for select second highest salary from table
AnswerBot
9mo
Query to select second highest salary from a table
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to select the second row after skipping the first row
Help your peers!
Add answer anonymously...
Popular interview questions of PHP Developer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app