Forwarded from Shivam Dugale
sql_day10_joins.pdf
3.8 KB
Q. Which JOIN returns only matching records from both tables?
Anonymous Quiz
8%
LEFT JOIN
76%
INNER JOIN
16%
FULL JOIN
0%
RIGHT JOIN
Q. Which JOIN is used to join a table with itself?
Anonymous Poll
6%
FULL JOIN
79%
SELF JOIN
14%
INNER JOIN
1%
LEFT JOIN
What does a SQL function return?
Anonymous Quiz
34%
Multiple rows
33%
Single value
5%
Nothing
27%
Table