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 |
List the ways in which dynamic sql can be executed?
Can we insert data into view sql server?
What is indexing in sql server with example?
How to enter date and time literals in ms sql server?
what is create database syntax? : Sql server database administration
Define inner join? Explain with an example?
How to insert a new row into a table with "insert into" statements in ms sql server?
What are sql server functions?
What do you understand by physical_only option in dbcc checkdb?
How do you size a resultset?
How to provide values to stored procedure parameters in ms sql server?
What is clustered index