Computer Science for IGCSE & O level - Databases (Section 2 - No. 18)

Which SQL command would you use to display the contents of a table?

DISPLAY * FROM table_name;

SHOW TABLE table_name;

SELECT * FROM table_name;

VIEW TABLE table_name;

The SELECT statement is used to query and retrieve data from a table.