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

SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the most common trace flags used with sql server?

1052


What is the beast way to write CTE in SQL Server ?

1051


Define constraints and give an example of their use?

1043


on line cluster can we make if yes tell me the procedure

2025


Explain what is log shipping?

1141


How would you use user_constraints table in DB?

1009


Difference between aggregate functions of sql?

1107


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1047


How to get the definition of a stored procedure back?

977


What is acid db?

891


How to list all objects in a given schema?

1064


How the authentication mode can be changed?

1137


What is scrollable cursor?

1044


What is ssl in sql server?

1082


How do I start sql server 2016?

915