Which clause is used to filter grouped data?
Anonymous Quiz
8%
WHERE
61%
GROUP BY
28%
HAVING
3%
ORDER BY
Which SQL function is used to convert text into uppercase?
Anonymous Quiz
1%
LOWER ()
94%
UPPER ()
3%
CAPITAL ()
2%
CONVERT ()
Which function is used to get the current date in SQL?
Anonymous Quiz
31%
GETDATE()
12%
TODAY()
43%
CURRENT_DATE
15%
NOWDATE()
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