Which SQL command is used to specify the information you want to retrieve?

Prepare for the OCR GCSE Computer Science Paper 2 exam. Practice with diverse questions, flashcards, and detailed explanations. Boost your confidence and ace your test!

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.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy