Which of the query in SQL is an example of self-join?
I. SELECT a.column_name FROM table1 a, table1 b WHERE a.x = b.x;
II. SELECT b.column_name FROM table1 a, table2 b WHERE a.y = b.y;1
Only I
2
Only II
3
Both I and II
4
None of these
Which of the query in SQL is an example of self-join?
I. SELECT a.column_name FROM table1 a, table1 b WHERE a.x = b.x;
II. SELECT b.column_name FROM table1 a, table2 b WHERE a.y = b.y;