Quiz di SQL: Self Join

This SQL quiz covers self joins, where one table appears twice under different aliases. You will read employee-manager hierarchies, compare each row with another row of the same table and avoid counting pairs twice, the kind of question that shows up in SQL interviews.

Difficile 10 domande ~8 minuti Superato con il 80% SQLite

Scegli una modalità

Stai giocando come ospite: accedi per salvare XP e serie.

Domanda di esempio

Domanda 1 di 10

What does this print?

CREATE TABLE employees (id INTEGER, name TEXT, manager_id INTEGER);
INSERT INTO employees VALUES (1, 'Ana', NULL), (2, 'Ben', 1), (3, 'Cal', 1), (4, 'Dee', 2);
SELECT e.name, m.name
FROM employees e
JOIN employees m ON m.id = e.manager_id
ORDER BY e.name;
Mostra la risposta

B. Ben|Ana Cal|Ana Dee|Ben e plays the employee and m the manager, matched through e.manager_id. Ana has no manager, so the inner join drops her; a LEFT JOIN would keep her with a NULL manager.

Cosa copre questo quiz

  • Aliases that let one table play two roles
  • Employee-manager hierarchies and multi-level joins
  • Comparing rows: earning more than the manager, warmer than yesterday
  • Unique pairs with a.id < b.id
  • When a recursive CTE is the better tool

Domande frequenti

Serve un account?

No. Chiunque può giocare. Accedi per salvare XP, serie, badge e cronologia.

Posso rifarlo?

Sì. Il tuo miglior punteggio resta salvato, e domande e risposte vengono mescolate ogni volta.