Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, model, klasa, pojemnosc, energia, ntile_poj, ntile_ene,
- (NTILE_POJ * 0.6 + NTILE_ENE * 0.4) klasyfikacja
- FROM
- (SELECT RANK() OVER (PARTITION BY klasa ORDER BY pojemnosc) NTILE_POJ,
- RANK() OVER (PARTITION BY klasa ORDER BY energia DESC) NTILE_ENE,
- klasa, pojemnosc, energia, model, id
- FROM lodowki)
- ORDER BY klasyfikacja DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement