Rev Up for Success with the 2026 OCR GCSE Computer Science Paper 2 Practice Extravaganza!

The SQL command used to specify the information you want to retrieve is SELECT. This command allows users to define which columns of data from a database table they wish to view. By using SELECT, you can choose specific fields or whole tables to return results that meet certain criteria.

The command FROM works in conjunction with SELECT to indicate the table from which the data is being retrieved. While WHERE is used to filter records based on specific conditions, it does not define what information is to be retrieved. INSERT is a command used to add new data to a database rather than retrieve existing data. Therefore, SELECT is the key command for specifying the data to be retrieved in a query.