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 the 3rd max salary

Answer Posted / udaya

select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

996


What samples and sample databases are provided by microsoft?

1022


How do you Implement SSIS Packages in your Project?

1904


What are the common performance issues in sql server?

897


How to recreate an existing index in ms sql server?

1030


What is the full meaning of dml?

934


What are sql server procedures?

957


What are the advantages dts has over bcp?

974


Explain the ways to controlling cursor behavior?

901


How do I create a trace in sql server?

1007


How do you rename a table in sql server?

1001


How to create a scrollable cursor with the scroll option?

977


List the different types of joins?

965


Can I work with several databases simultaneously? : sql server management studio

968


What is the difference between functions and stored procedures?

1134