In SQL, what does the statement structure SELECT FROM WHERE do, and provide a simple example.

In SQL, what does the statement structure SELECT FROM WHERE do, and provide a simple example.

• A. It counts total records.
• B. SELECT specifies columns, FROM indicates table, WHERE filters rows; example: SELECT FirstName, Salary FROM Employees WHERE Department='Sales'.
• C. It sorts results.
• D. It creates a new database.

Answer: (B)

Retrieving data with this structure means choosing what to show, where it comes from, and which rows to include. SELECT lists the columns you want to appear in the result. FROM specifies the table you’re querying. WHERE applies a condition to filter rows so only those that meet the criterion are returned. For example, SELECT FirstName, Salary FROM Employees WHERE Department='Sales' returns the first name and salary for every employee whose department is Sales. It doesn’t count records (that would use an aggregate like COUNT), nor does it sort results (that would be ORDER BY), nor does it create a new database (that would be CREATE DATABASE). You can also tweak it with different columns, different tables, or more complex conditions using AND/OR, LIKE, or comparison operators.

Retrieving data with this structure means choosing what to show, where it comes from, and which rows to include. SELECT lists the columns you want to appear in the result. FROM specifies the table you’re querying. WHERE applies a condition to filter rows so only those that meet the criterion are returned. For example, SELECT FirstName, Salary FROM Employees WHERE Department='Sales' returns the first name and salary for every employee whose department is Sales. It doesn’t count records (that would use an aggregate like COUNT), nor does it sort results (that would be ORDER BY), nor does it create a new database (that would be CREATE DATABASE). You can also tweak it with different columns, different tables, or more complex conditions using AND/OR, LIKE, or comparison operators.