Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 57 of 78

Simple Queries in SQL — Question 11

Back to all questions
11
Question

Question 11

The ............... clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.

  1. Where
  2. from
  3. having
  4. like
Answer

Where

Reason — The WHERE clause in SELECT statement specifies the criteria for selection of rows to be returned. When a WHERE clause is present, the database program goes through the entire table one row at a time and examines each row to determine if the given condition is true. If it is true for a row, that row is displayed in the output.