2021. máj 28.

Multiple tables in FROM

írta: dataanalyticsdemo
Multiple tables in FROM

Inspired by Leetcode "Consecutive numbers" question

Let's take this example table first:

Results in simple 8 lines:

When I use the same table 3 times in the FROM clause:

512 rows..But why? 8*8*8 = 512.

So you need to narrow that combination down with the commented part:

Now we have the same table, 3 times, without the weired combinations.

Szólj hozzá