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

What is spatial and temporal data?

978


What is ddl and dml commands?

889


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

916


How many instances per computer are there in sql server 2000?

1046


List out a number of the wants to setup a SQL Server failover cluster?

1047


How to create a new login name in ms sql server?

1043


What do you understand by triggers?

899


What is the name of the system variable that returns the number of rows affected by a SQL statement?

993


Define left outer join in sql server joins?

946


What is the contrast between sql and pl/sql?

1117


What is difference between rownum and row_number?

946


Differentiate between a local and a global temporary table?

941


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1016


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1019


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1972