Back to All Flashcards
Card 1 of 5 0%
0Hard
0Learning
0Know It
Question
Loading…
Click to reveal answer
Answer
All 5 Cards
#1
Q: Basic SELECT statement?
A: SELECT column1, column2 FROM table_name WHERE condition;
#2
Q: What does INNER JOIN do?
A: Returns rows where the join condition matches in both tables.
#3
Q: Difference between WHERE and HAVING?
A: WHERE filters rows before grouping; HAVING filters groups after GROUP BY.
#4
Q: What is a primary key?
A: A column (or set of columns) that uniquely identifies each row in a table.
#5
Q: What does COUNT(*) do?
A: Counts all rows in the result set (including NULLs).
Explore All 125 Free Decks