When writing a SELECT statement, which of the following clauses is used to define specific rows to be returned from a table?
A. FROM: This clause specifies the table(s) from which data will be retrieved.
B. WHERE: This clause defines a condition that filters the rows based on specific criteria.
C. ORDER BY: This clause sorts the retrieved rows based on a specified column or columns.
D. GROUP BY: This clause groups the retrieved rows based on a shared value in one or more columns.
Choose the most appropriate answer from the options given below:
1
A only
2
B only
3
B and C only
4
A, B, and C only