Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Leetcode 569. Median Employee Salary
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--PostgreSQL 9.6 --'\\' is a delimiter drop table if Exists Employee; Create table Employee("id" int, "company" varchar(30), "salary" int); insert into Employee("id", "company", "salary") values (1, 'A', 2341), (2, 'A', 341), (3, 'A', 15), (4, 'A', 15314), (5, 'A', 451), (6, 'A', 513), (7, 'B', 15), (8, 'B', 13), (9, 'B', 1154), (10, 'B', 1345), (11, 'B', 1221), (12, 'B', 234), (13, 'C', 2345), (14, 'C', 2645), (15, 'C', 2645), (16, 'C', 2652), (17, 'C', 65); select Id, company, salary from ( select Id, company, salary, row_number() over(partition by company order by salary asc) as asc_rownum, row_number() over(partition by company order by salary desc) as desc_rownum from employee ) as subq where subq.asc_rownum in (subq.desc_rownum - 1, subq.desc_rownum + 1, subq.desc_rownum)
absolute service time: 0,47 sec
edit mode
|
history
|
discussion
id
company
salary
1
6
A
513
2
5
A
451
3
9
B
1154
4
12
B
234
5
14
C
2645