find 2nd highest salary of person using cursor concept?
Answers were Sorted based on User's Feedback
Answer / amruta dash
select max(salary) from tbl where salary not in (select max
(salary) from tbl);
Is This Answer Correct ? | 11 Yes | 6 No |
Answer / jcreddy
select e1.salary from employee e1
where 1 = (select count(salary) from employee e2 where
e1.salary < e2.salary)
order by marks asc
-- by changeing from '<', to '>' you will get min salary
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manju
DECLARE authors_salary CURSOR
select top2(salary) from tb_employee order by desc salary
open author_salary
FETCH NEXT FROM authors_salary into @topsalary
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / krish
select max(sal) frem tbl where sal <(select max(sal) from tbl;
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pawan
select * from emp a where 2=(select count(distinct(sal)) from emp b where a.sal<=b.sal);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / b.mamatha
select * from tabl1 where salary=(select max(salary) from
tabl1 where salary<(select max(salary) from tabl1)
Is This Answer Correct ? | 0 Yes | 1 No |
How to get @@error and @@rowcount at the same time?
how we can use a database with php.
What is the difference between temp table and table variable?
What do you mean by SQL injection attack?
can primery key be a non clustered index?
Do you know what is sql service broker?
What are the triggers in sql?
Can we use pragma autonomous_transaction in trigger?
What objects does the fn_my_permissions function reports on? : sql server security
What is Extended user-defined?
How you can minimize the deadlock situation?
What is the difference between functions and stored procedures?