How to get 2nd highest value in SQL
AnswerBot
7mo
Use the ORDER BY and LIMIT clauses to get the 2nd highest value in SQL.
Use ORDER BY clause to sort the values in descending order
Use LIMIT 1,1 to get the second row after skipping the first row
Help your peers!
Add answer anonymously...
Popular interview questions of Business Intelligence Analyst
Top HR questions asked in Element14 Business Intelligence Analyst
>
Element14 Business Intelligence Analyst Interview Questions
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