Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


find 2nd highest salary of person using cursor concept?

Answers were Sorted based on User's Feedback



find 2nd highest salary of person using cursor concept?..

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

find 2nd highest salary of person using cursor concept?..

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

find 2nd highest salary of person using cursor concept?..

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

find 2nd highest salary of person using cursor concept?..

Answer / krish

select max(sal) frem tbl where sal <(select max(sal) from tbl;

Is This Answer Correct ?    3 Yes 1 No

find 2nd highest salary of person using cursor concept?..

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

find 2nd highest salary of person using cursor concept?..

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

Post New Answer

More SQL Server Interview Questions

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  


What are the 2 types of classifications of constraints in the sql server?

0 Answers  


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  


How to count rows with the count(*) function in ms sql server?

0 Answers  


Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  


What is normalization and what are the different forms of normalizations?

2 Answers  


Explain what is the difference between a local and a global temporary table?

0 Answers  


What is the osql utility?

0 Answers  


Mention the different types of triggers?

0 Answers  


What are the different editions available in sql server 2000?

0 Answers  


How to drop an existing table?

0 Answers  


Explain syntax for disabling triggers?

0 Answers  


Categories