SELF JOIN IN SQL

Question

let's say we have a single column table
id
2
a
b
D
null

if we do self join or inner join to same table what will be the output? is null considered or not?

Answer 1

I've gone through that bro but my question is what will be the output if on of the values is null

Answer 2

hey thanks man!