Skip to content

Latest commit

 

History

History
15 lines (14 loc) · 386 Bytes

File metadata and controls

15 lines (14 loc) · 386 Bytes

problem of join

create table a (Id int)
create table b (Id int)
insert into a values(1),(1),(1),(1),(1)
insert into b values(1),(1),(1)

guess the result for each query below:

select count(*) from a inner join b on a.id =b. id
select count(*) from a left join b on a.id =b. id
select count(*) from a full join b on a.id =b. id
select count(*) from a cross join b