Use comparison operators to write a question that the database will understand. Which records contain "no"?

Responses

<>no
<>no

=no
=no

=yes
=yes

is no
is no

1 answer

To write a question that the database will understand for finding records that contain "no" using comparison operators, you can use the following query:

WHERE column_name = 'no'

or if you want to find records that do not contain "no":

WHERE column_name <> 'no'

In this case, if you want to specifically find records containing "no", you would use = 'no'. Therefore, the most relevant questions based on your options are:

  • = no
  • is no

Depending on the specific syntax of your database, one of these would be correct. However, "=no" is typically the standard SQL syntax.