I had phone interview with an engieer in box. At the beginning, he briefly discribed what his team responsible for, the culture of his team and company. And then we moved into the technical questions. The process lasted half an hour and he asked me one algorithm question and one sql question. Since the job position for his team is to hire some one with software development experience as well as sql process capacity. He asked one sql question.
Interview questions [2]
Question 1
Given an integer array ,determine the element that occur most frequently in this array
assume you have a table named load_errors, it has many cols: one of the cols i s starttime.
write the query to get 10 most recent errors from this table