Am I missing something about joins? I’m not finding any resources that
calls a full join a Cartesian product. Everything I’m seeing says a cross
join is Cartesian product and full join is basically an outer join on both
tables.
László Kátai-Pál March 5, 2015
The audience is not passed a microphone so it would be useful if the
presenter repeated the question.
Tammy Burcham March 5, 2015
I wish the audio was better. Most of the time I can just hear that he is
speaking. I am not catching all that he is saying.
A pedantic note – I think ‘row number’ would be an equivalent of Oracle’s
‘Rownum’ not ‘rowid’.
Rownum is the number of the row in the order it is returned, and would be
1,2,3,4. Rowid is the physical address of the row 0 it’s an encoded
representation of the file and block address – looks like this:
AAAAECAABAAAAgiAAA
Mahbubul Alam March 5, 2015
Excellent Presentation. I believe, it has been completed all necessary
topics in a single presentation.
Am I missing something about joins? I’m not finding any resources that
calls a full join a Cartesian product. Everything I’m seeing says a cross
join is Cartesian product and full join is basically an outer join on both
tables.
The audience is not passed a microphone so it would be useful if the
presenter repeated the question.
I wish the audio was better. Most of the time I can just hear that he is
speaking. I am not catching all that he is saying.
Grouping ID was incorrect.
Region, Country, Category = 111 = 7
Country, Category = 011 = 3
Region, Category = 101 = 5
Category = 001 = 1
Great presentation – really useful.
A pedantic note – I think ‘row number’ would be an equivalent of Oracle’s
‘Rownum’ not ‘rowid’.
Rownum is the number of the row in the order it is returned, and would be
1,2,3,4. Rowid is the physical address of the row 0 it’s an encoded
representation of the file and block address – looks like this:
AAAAECAABAAAAgiAAA
Excellent Presentation. I believe, it has been completed all necessary
topics in a single presentation.