Question: Write a query to find the second largest value in a given column of a table

Answer: To find the second largest salary amount from employee table. select max(salary) from employees where pin < (select max(salary) from employees)
    © NewInterviewQuestions.com



This Question is published on http://www.newinterviewquestions.com/interview/9769. Post your own questions
in New Interview Questions.com (http://www.newinterviewquestions.com)