By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
Records: 1 Duplicates: 0 Warnings: 0
| id | name | salary | DeptId | rownum |
|---|---|---|---|---|
| 1 | joe | 60 | 1 | 0 |
| 2 | ralph | 30 | 1 | 3 |
| 3 | joel | 50 | 1 | 2 |
| 4 | tracy | 55 | 1 | 1 |