Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top N Rows Per Group

Medium
SQL & Data ManipulationWindow FunctionsRankingCTEsAsked 1 times

Problem

Write a SQL query to get the top N rows per group.

Practicing as: Data Engineer interview at Henkel

Hi, I'll play your Henkel interviewer for the Data Engineer role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Next questions
Top N Per Group SQLMediumTop N Per Group QueryMediumTop N Records Per GroupHard