Exam-style question
Try this first
Which SQL statement retrieves all columns from a table named Student?.
- A.SELECT * FROM Student;
- B.INSERT * INTO Student;
- C.UPDATE * FROM Student;
- D.DELETE * FROM Student;
Model answer
What a good answer should say
- SELECT * FROM Student;
Explanation
Why this works
SELECT is used to retrieve data. The asterisk represents all columns, and FROM identifies the table.
Common mistake
No common mistake is linked to this question yet.