0
Could someone explain me what is wrong with my syntax/use of the RANK function?
Problem situation: "Rank songs by band so that songs of higher duration occupy the first places. Present band name and music and ranking position."
SELECT MU.NOME, BA.NOME
RANK() OVER (PARTITION BY MU.TEMPO_DURACAO ORDER BY BA.NOME)
FROM MUSICA MU, BANDAS_E_ARTISTAS BA, BANDA BD
WHERE BA.ID = BD.ID
Seems to lack the condition of John of "MUSIC" generating an improper Cartesian prodoto.
– Motta