Question d’entretien chez BlackRock

Un-pivot a given table from columns to rows

Réponse à la question d'entretien

Utilisateur anonyme

23 janv. 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.