The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.*Where, fromFrom, selectSelect, fromFrom, where

___________ clause is used to retrieve data from one or more tables?Select one:WhereOrder bySelectHaving

What is the purpose of the WHERE clause in a SQL query?Select one:a. To specify the order of the resultsb. To group rows into subsetsc. To specify the columns to be retrievedd. To filter rows based on a condition

SELECT, FROM and WHERE are mandatory for any SELECT statement in SQL.

Which of the following statements is TRUE regarding the application of WHERE clause? Can only be used on columns that are present in SELECT clauseIs used to choose the columns that need to be fetched in the resultCan be used on all columnsNone of the above

When to use SQL WHERE clause?Answer choicesSelect an optionTo limit the column data that are returned.To limit the row data are returned.Both A and B are correctNeither A nor B are correct.