Data Retrieval from Multiple Tables Flashcards
1
Q
What keyword is used to combine rows from two tables?
A
JOIN
2
Q
What is the default sorting order in ORDER BY?
A
Ascending (ASC)
3
Q
What SQL clause filters data before aggregation?
A
WHERE
4
Q
Which clause filters groups after aggregation?
A
HAVING
5
Q
What function returns the number of rows?
A
COUNT()
6
Q
How do you perform a self-JOIN?
A
Join a table to itself using aliases
