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

How many types of objects are there?

0 Answers  


What is ems sql management studio? : sql server management studio

0 Answers  


How do you check sql server is up and running?

0 Answers  


How to update values in a table with update statements in ms sql server?

0 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  


what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


How to enter binary string literals in ms sql server?

0 Answers  


How to view existing indexes on an given table using sp_help?

0 Answers  


how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,


What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  


How to drop an existing stored procedure in ms sql server?

0 Answers  


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,


Categories