[Solved] Write SQL query to fetch data from below table [closed]

Question

This is not the complete solution. Just a hint for you to do your homework.

select a.column3 + b.column3 from
mytable a, mytable b
where a.column1 = b.column2
and a.column2 = b.column1;

Accepted Answer

This is not the complete solution. Just a hint for you to do your homework.

select a.column3 + b.column3 from
mytable a, mytable b
where a.column1 = b.column2
and a.column2 = b.column1;