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 / karthik

select min(salary) from (select top 3 * from employee order by salary desc) temp

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

905


Explain tables in SQL Azure?

120


What is simple indexing method?

972


What are the parts of a function?

876


What is dbcc updateusage?

1155


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

932


What happens if null values are involved in arithmetic operations?

964


What are the two authentication modes in sql server?

1062


List the different types of joins?

929


What is public role in sql server?

1070


How do you handle datasets larger than 50 gb?

162


What are dml triggers and types of dml triggers?

924


What are the different types of sub-queries?

997


What is multi-statement table-value user-defined function?

938


How do you create type- insensitive operator?

995