Python-Quizze: #joins

5 Quizze zu #joins, mit Erklärung zu jeder Antwort.

1 INNER JOIN Leicht Match rows from two tables with INNER JOIN and predict which rows come out. SQL · SQL Joins #joins#inner-join 10 Fragen · ~5 Min. Nicht begonnen Starten
2 LEFT JOIN Mittel Keep every row of the left table with LEFT JOIN and handle the NULLs it creates. SQL · SQL Joins #joins#left-join 10 Fragen · ~6 Min. Nicht begonnen Starten
3 Self Join Schwer Join a table to itself to read hierarchies, compare rows and find pairs. SQL · SQL Joins #joins#self-join 10 Fragen · ~8 Min. Nicht begonnen Starten
4 Join Pitfalls Schwer Catch the join mistakes that silently duplicate rows, lose rows or inflate totals. SQL · SQL Joins #joins#gotchas 10 Fragen · ~8 Min. Nicht begonnen Starten
5 UNION & CROSS JOIN Mittel Stack query results with UNION and UNION ALL and build every combination with CROSS JOIN. SQL · SQL Joins #union#joins 10 Fragen · ~6 Min. Nicht begonnen Starten

Weitere Tags: