SQL QuestSQL Interview Prep › Goldman Sachs

Goldman Sachs SQL Interview Questions

The reported pipeline starts with an algorithm-heavy online test and a recorded video interview; the SQL arrives in the live technical rounds — removing duplicates, recovering the latest value, aggregating across two or three tables.

Start the Goldman Sachs set — free Check my readiness

16 practice challenges · 4 Easy / 7 Medium / 5 Hard · 12 play free · runs in the browser

How the interview runs

The Goldman Sachs SQL interview, as candidates report it

Goldman Sachs does not publish the format. Each row is what candidates and prep guides have described publicly, with its source; where sources disagree, the row says so. Formats change — treat every specific as reported, not official.

Overall pipelineAn online assessment, a recorded video interview, a live coding round, then a final "Superday".[1]
The online assessmentReported as mostly data-structures and algorithms with multiple choice; SQL is not mentioned in the reports we could read.[2]
Where SQL appearsOne 2024 analyst report describes two hour-long technical rounds with SQL: removing duplicate records from a table with no unique key, and salary questions across employees, salary history and departments.[3]
Reported difficultyEasy-to-medium SQL inside a process whose early rounds lean on algorithms.[3][1]
  1. [1] Exponent — Goldman Sachs interview process guide (published 2024)
  2. [2] LinkJob — Goldman Sachs HackerRank assessment notes (24 Sep 2025)
  3. [3] GeeksforGeeks — Goldman Sachs Analyst interview experience (experienced hire) (2024)
  4. [4] DataLemur — Goldman Sachs SQL interview questions (14 Mar 2025)

Sources: Exponent — Goldman Sachs interview process guide (published 2024); LinkJob — Goldman Sachs HackerRank assessment notes (24 Sep 2025); GeeksforGeeks — Goldman Sachs Analyst interview experience (experienced hire) (2024); DataLemur — Goldman Sachs SQL interview questions (14 Mar 2025). Accessed 13 Sep 2026.

The SQL that comes up

What Goldman Sachs SQL questions test

Reported most often, in order

  • 1Deduplication and keeping one copy
  • 2Latest record per key (window functions or a self-join)
  • 3Joins across two or three tables
  • 4Aggregation — and HAVING vs WHERE
  • 5Running totals
  • 6Top-N groups (e.g. departments by average salary)
  • 7"Currently active" logic with start and end dates

Difficulty: Reported as easy-to-medium SQL; the harder filter is the algorithm test before it. The data is client transactions by asset type, trades by client segment, and salary or position history with effective dates.

Our Goldman Sachs practice set, by skill

The 16 SQL Quest challenges tagged Goldman Sachs, resolved onto the nine Skillmap skills. A challenge exercises several skills, so shares do not sum to 100%. This is the composition of the practice set on this page, not a measurement of Goldman Sachs’s interview.

Sample questions

Goldman Sachs SQL question shapes, and where to practise them

Shapes candidates and guides report (paraphrased)

Practise now — SQL Quest challenges matched to those patterns

Our challenges, chosen because their SQL matches the shapes above; not questions Goldman Sachs has asked. Each card opens the challenge in the browser — no signup.

Open all 16 Goldman Sachs practice challenges →

Skillmap

How ready are you for the Goldman Sachs SQL round?

Ten questions, no signup. You get a readiness score weighted to the SQL this page covers, your Skillmap across joins, window functions, aggregation and the rest, and the weakest skill to practise first.

Check my Goldman Sachs readiness Start the Goldman Sachs set

Frequently asked

Drill the skills the Goldman Sachs set leans on, one at a time: CTE practice · GROUP BY exercises · Window function practice · JOIN practice · Date function practice — or browse every SQL practice question.

Every question in the Goldman Sachs set, one page each with the schema and a hint: Average Salary by Department · Top 5 Earners · A Subquery That Returns One Value · Monthly Spend Per Account · Below Department Average · Find Duplicate Emails · GROUP BY + HAVING · Most Recent Order Per Customer (ROW_NUMBER) · Delete Duplicate Records, Keep the Original · Each Merchant's Share of Its Category · Running Total of Daily Card Spend · Running Total Revenue · Top Earner Per Department · Deduplicate Orders with ROW_NUMBER · Second Highest Salary per Department · Top 3 Banks Per State by Assets.

Ready for the Goldman Sachs SQL round?

No signup, no card. Start with the free challenges in the set; the Skillmap shows what to fix before the interview.

Start the Goldman Sachs set — free