Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
You can use search criteria to restrict the number of rows returned by a query.
For details about the particular steps to creating search criteria, refer to the topics listed in the following table.
In this section
| Article | Description |
|---|---|
| Rules for entering search values | Explains how to enter text, numbers, dates, or logical values. |
| Conventions for combining search conditions in the Criteria pane | Explains the concepts behind using the AND and OR operators. |
| Specify search conditions | Explains the basics of choosing search criteria to get just the data you want. |
| Specify multiple search conditions for one column | Explains how to create multiple search conditions to the same data column. |
| Specify multiple search conditions for multiple columns | Explains how to include several data columns as part of the search condition for a query. |
| Specify the TOP clause in queries | Explains how to have only a given number or percentage of rows returned. |
| Use HAVING and WHERE clauses in the same query | Explains how and why to use both of these clauses in a query. |
| Select rows that don't match a value | Explains how to return all rows where the value of a give column doesn't match the value you provide in the query statement. |
| Include or Exclude Rows | Explains the concepts behind clauses and operators used in queries. |
| Exclude duplicate rows | Explains how to filter duplicate rows out of Select queries. |
| Combine conditions when AND has precedence | Explains why and how to use the AND operator to filter query results. |
| Combine conditions when OR has precedence | Explains why and how to use the OR operator to filter query results. |
| Create subqueries | Explains how to create subqueries, or nested queries. |