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...


please tell me the query to get details of the employee
having the second largest salary

Answers were Sorted based on User's Feedback



please tell me the query to get details of the employee having the second largest salary..

Answer / ravikiran

select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL Server Interview Questions

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

2 Answers  


How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  


How to find the list of fixed hard drive and free space on server?

0 Answers  


how to rest identity columns in sql server

3 Answers   Matrix,


What are different types of collation sensitivity?

0 Answers  


What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  


There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  


hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  


How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,


How can I get data from a database on another server?

0 Answers  


What is the difference between indexing and hashing?

0 Answers  


Categories