Pergunta de entrevista da empresa Amazon: Describe with a written code example the usage of an Oracle RANK OVER PARTITION BY analytic function | Glassdoor

Ir para o conteúdo Ir para a pasta

employer cover photo

Amazon

Entrevista do cargo de Business Intelligence Engineer da empresa Amazon

Pergunta de entrevista da empresa Amazon

Entrevista para Business Intelligence Engineer

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

Respostas da entrevista

Sigiloso

25 de jan. de 2016

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

2

Sigiloso

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

2

Buscas relacionadas: Avaliações da empresa Amazon | Vagas da empresa Amazon | Salários da empresa Amazon | Benefícios da empresa Amazon

Entrevistas da empresa Amazon