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

When to use Inner join & when to use subquery?

1171


how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1069


What information is maintained within the msdb database?

987


What is a file group?

1101


Can we add our custom code in ssis?

994


What stored by the master? : sql server database administration

1115


What is the purpose of floor function?

1045


How many non clustered indexes there can be on table ?

923


What is the purpose of the model database?

1023


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1061


What is user defined stored procedures?

952


What are the different Authentication modes in SQL Server and how can you change authentication mode?

1094


What is trigger explain with program?

988


Explain the truncate command? : SQL Server Architecture

1183


What are commonly used odbc functions in php?

1020