how to find 2nd highest salary in random database salary of employer.....

Question Posted / ravi.28_roy

Answers were Sorted based on User's Feedback

how to find 2nd highest salary in random database salary of employer.......

Answer / narendra sharma

select column_name from table_name order by column_name
desc limit 1,1

Is This Answer Correct ?

12 Yes

6 No

how to find 2nd highest salary in random database salary of employer.......

Answer / arnab das

select distinct column_name from table_name order by
column_name desc limit 1,1

Is This Answer Correct ?

6 Yes

4 No

how to find 2nd highest salary in random database salary of employer.......

Answer / rajasekhar.s

select distinct a.sal from emp a where
n=(select count(distinct b.sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

1 Yes

1 No

how to find 2nd highest salary in random database salary of employer.......

select emp_name, salary from employee where salary = (select MAX(salary) from employee
WHERE salary <> (select MAX(salary) from employee ))

Is This Answer Correct ?

0 Yes

0 No