Rank vs Dense_Rank in SQL

select
Department,
Employee,
salary,
rank
from (
select
DepartmentId as Department,
name as Employee,
salary,
RANK() OVER (partition by DepartmentId order by salary desc) as rank
from Employee)temp
where temp.rank=1;

--

--

--

Data Engineering | Machine Learning | Front-end | NIT Trichy

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to Install Hasura GraphQL Engine for PostgreSQL-Based Applications

Using Github Actions with Repository Dispatch Event

Should You Learn Python Or R?

Telenor Quiz Today -Check Updated Quiz Here | Telenor Answers Today [dt] [month] [year]

TIL 0627 Final Team Project

Why Self-Taught Developers Are Great Pick

Query Store: A Better Execution Plan Alert

Graphic shows two computers, each with a different version of an execution plan diagram.

Unified PubSub Client at Pinterest

The main components of PSC are PSC Consumer Module and PSC Backend Consumer, PSC Producer Module and PSC Backend Producer. A backend client for each PubSub implements the Backend Consumer/Producer interfaces. There are add-on components such as metrics, service discovery, interceptors, etc.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Parmanand kumar

Parmanand kumar

Data Engineering | Machine Learning | Front-end | NIT Trichy

More from Medium

Embedded SQL and Dynamic SQL

Dynamic SQL and Embedded SQL

Ease into SQL