Computer Science for IGCSE & O level - Databases (Section 1 - No. 23)

What is the correct SQL command to retrieve all fields from a table named 'Patients'?
SELECT * FROM Patients;
GET * FROM Patients;
DISPLAY * FROM Patients;
SHOW * FROM Patients;

Explanation

The `SELECT * FROM` statement is used to retrieve all fields from a specified table.

Comments (0)

Advertisement