BlackRock Interview Question
Un-pivot a given table from columns to rows
Interview Answer
Anonymous
Jan 23, 2026
Solution was using Lateral View Explode but I approached in a CASE WHEN and UNION ALL which was not accepted because The interview panel guy only wanted to accept solution which he had in his mind.