Domande di colloquio di Amazon: Describe with a written code example the usage of an Oracle RANK OVER PARTITION BY analytic function | Glassdoor

Passa al contenuto Passa al piè di pagina

employer cover photo

Amazon

Colloquio per Business Intelligence Engineer presso Amazon

Domanda di colloquio di Amazon

Colloquio per Business Intelligence Engineer

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

Risposte di colloquio

Anonimo

25 gen 2016

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

2

Anonimo

31 mar 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

Ricerche correlate: Recensioni su Amazon | Offerte di lavoro di Amazon | Stipendi di Amazon | Benefit di Amazon

Colloqui di Amazon