Infosys interview question
Select count(*) from table1, table2; here table1 has 25 rows and table2 has 50 rows.
Interview Answer
Anonymous
6 Jul 2022
Cross join will happen here and also the where clause is not given. so answer will be 25 x 50.
Select count(*) from table1, table2; here table1 has 25 rows and table2 has 50 rows.
Anonymous
Cross join will happen here and also the where clause is not given. so answer will be 25 x 50.
Check out your Company Bowl for anonymous work chats.