Pregunta de entrevista en Amazon: Describe with a written code example the usage of an Oracle RANK OVER PARTITION BY analytic function

Amazon

Describe with a written code example the usage of an Oracle RANK OVER PARTITION BY analytic function

Anónimo

25 de ene de 2016

select Name,Subject,Marks, RANK() over(partition by name order by Marks desc)Rank From ExamResult order by name,subject

Anónimo

31 de mar de 2012

could you share more detail info about the interview questions? what type of them? algrothem? database? SQL query? BI tools ? data modeling? thanks