Question

Question # 24
GRey
Which of the following SQL command clause is used to filter the number of rows fetched?​

Answer 1

Explanation:

SQL Server provides the top clause to restrict the number of rows to be fetched

Answer 2

Answer:

Where clause

Where clause SQL command clause is used to filter the number of rows fetched.

Explanation:

The WHERE clause limits the number of rows returned by a SELECT query.

The WHERE clause compares values from columns, literals, arithmetic functions, and functions. The SQL WHERE clause is used to specify a condition when retrieving data from a single table or joining multiple tables. Only if the given condition is met does it return a specific value from the table. You should use the WHERE clause to filter the records and retrieve only those that are required.