nerdexam
Linux_Foundation

LFCS · Question #550

Which of the following words is used to restrict the records that are returned from a SELECT query based on supplied criteria for the values in the records?

The correct answer is C. WHERE. In SQL, the WHERE clause is used to filter rows from a SELECT statement based on specified conditions.

Submitted by takeshi77· Apr 18, 2026Operation of Running Systems

Question

Which of the following words is used to restrict the records that are returned from a SELECT query based on supplied criteria for the values in the records?

Options

  • ALIMIT
  • BFROM
  • CWHERE
  • DIF

How the community answered

(28 responses)
  • A
    4% (1)
  • C
    93% (26)
  • D
    4% (1)

Why each option

In SQL, the `WHERE` clause is used to filter rows from a `SELECT` statement based on specified conditions.

ALIMIT

The `LIMIT` clause restricts the number of rows returned, not based on criteria for values but by an absolute count.

BFROM

The `FROM` clause specifies the table or tables from which to retrieve data, not for filtering records based on values.

CWHERECorrect

The `WHERE` clause is a fundamental part of the SQL `SELECT` statement, allowing users to specify criteria that individual rows must satisfy to be included in the result set. This provides precise control over which records are retrieved from the database.

DIF

`IF` is a conditional statement often used in programming languages or within SQL functions/stored procedures, but it is not a standard clause for filtering `SELECT` query results directly.

Concept tested: SQL `SELECT` query filtering

Source: https://learn.microsoft.com/en-us/sql/t-sql/queries/select-from-where-transact-sql?view=sql-server-ver16

Topics

#SQL#Database querying#Data filtering#WHERE clause

Community Discussion

No community discussion yet for this question.

Full LFCS Practice