Which command specifies the tables to retrieve information from in SQL?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Study for the OCR GCSE Computer Science Exam. Prepare with flashcards, multiple choice questions, and hints. Get exam-ready with practical questions and answers!

The command used to specify the tables from which to retrieve information in SQL is the "FROM" clause. This clause is fundamental in SQL queries as it designates the source of the data being requested. When you execute a SELECT statement, the FROM clause indicates one or more tables that contain the data needed.

For example, in the statement SELECT * FROM Customers, "Customers" is the table from which the data is being retrieved. This command allows the database to understand exactly where to look for the information specified in the SELECT part of the query.

The other options serve different purposes in SQL statements. The WHERE clause filters records based on specified conditions, the ORDER BY clause sorts the result set, and the INSERT INTO command adds new records to a table. None of these directly indicate the source of the data like the FROM clause does.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy