How to find 2nd highest salary simple way in sql server



Finding Nth highest salary in a table is the most common question asked in interviews. I have displayed two ways.. 

1. Using sub Query-

Query: 

Select top 1 Salary From (Select distinct top 3 Salary From Employee order by Salary desc) emp order by Salary 

2. using dense_rank() function-

Query: 

Select Id, Name, Salary From (Select Id, Name, Salary, DENSE_RANK() Over (Order By Salary Desc) salary_rank From Employee) Emp Where salary_rank=2

 

Click here for youtube link

Comments

Post a Comment

Popular posts from this blog

Attribute-based routing in web api

Attribute-based routing is a feature in ASP.NET Web API (and ASP.NET Core MVC) that allows developers to define routes directly on controller actions or methods using attributes, rather than configuring routes in a centralized routing table. This approach enables developers to have more fine-grained control over routing, making the codebase more organized and easier to maintain. By decorating controller actions or methods with attributes like `[Route]`, `[HttpGet]`, `[HttpPost]`, `[HttpPut]`, `[HttpDelete]`, etc., developers can specify the HTTP method and route template for each action, directly within the controller itself. This approach simplifies routing configuration and makes it more intuitive, especially for RESTful APIs where HTTP methods have specific meanings. For example, in ASP.NET Core MVC, you can define routes like this: ```csharp-code [Route("api/[controller]")] public class ProductsController : ControllerBase {     [HttpGet]     public IActionResult ...
Read more

What is rest api

Image
A REST API (Representational State Transfer Application Programming Interface) is a set of rules and conventions for building and interacting with web services. It is based on the principles of REST, which include using standard HTTP methods and working with resources in a stateless manner. Here's a simple example of a REST API: Suppose you have a web service for managing a collection of books. You could define various RESTful endpoints like: 1. **GET /books**: This endpoint retrieves a list of all books. 2. **GET /books/{id}**: This endpoint retrieves details about a specific book by its ID. 3. **POST /books**: This endpoint creates a new book by sending a JSON object in the request body. 4. **PUT /books/{id}**: This endpoint updates the details of a specific book by its ID. 5. **DELETE /books/{id}**: This endpoint deletes a specific book by its ID. For example, if you want to retrieve information about a book with an ID of 123, you would make a GET request to `https:/...
Read more