Question

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

A) EXISTS
B) FROM
C) SELECT
D) SET
E) WHERE

Answer 1

E) WHERE

The SQL keyword to specify conditions for selecting rows is WHERE. It's used to filter records in a database according to certain criteria.

Step-by-step explanation:

In an SQL query, the keyword used to state the condition that specifies which rows are to be selected is WHERE. The WHERE clause is utilized to filter records based on specified conditions, allowing for more precise selection of data from a database.

For example, if you are querying a database for a list of students who scored above 80 on a test, you would use a WHERE clause to only select the rows where the score is greater than 80.

The SQL keyword used to state the condition that specifies which rows are to be selected is WHERE. This keyword is used in the SELECT statement to filter rows based on specified conditions. It allows you to specify criteria that the data must meet in order to be included in the result set.