Skip to content

Instantly share code, notes, and snippets.

@vincentdesmares

vincentdesmares/window-function-5.txt

Created May 12, 2017 00:17
Show Gist options
  • Save vincentdesmares/ca9e0932f043df8600f1c8bebb3e89d0 to your computer and use it in GitHub Desktop.
Save vincentdesmares/ca9e0932f043df8600f1c8bebb3e89d0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
window-function-5.txt
id | name | salary | category | row_number
------+-------------------+--------+----------+------------
4023 | Employe name 4023 | 9996 | A | 1
3795 | Employe name 3795 | 9993 | A | 2
1050 | Employe name 1050 | 9990 | B | 1
2664 | Employe name 2664 | 9988 | B | 2
956 | Employe name 956 | 9996 | C | 1
2843 | Employe name 2843 | 9986 | C | 2
607 | Employe name 607 | 9976 | D | 1
4983 | Employe name 4983 | 9970 | D | 2
1455 | Employe name 1455 | 9997 | E | 1
1528 | Employe name 1528 | 9990 | E | 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment