Edit

Specify Search Criteria (Visual Database Tools)

  • Article

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

Rules for Entering Search Values (Visual Database Tools)
Explains how to enter text, numbers, dates, or logical values.

Conventions for Combining Search Conditions in the Criteria Pane (Visual Database Tools)
Explains the concepts behind using the AND and OR operators.

Specify Search Conditions (Visual Database Tools)
Explains the basics of choosing search criteria to get just the data you want.

Specify Multiple Search Conditions for One Column (Visual Database Tools)
Explains how to create multiple search conditions to the same data column.

Specify Multiple Search Conditions for Multiple Columns (Visual Database Tools)
Explains how to include several data columns as part of the search condition for a query.

Specify the TOP Clause in Queries (Visual Database Tools)
Explains how to have only a given number or percentage of rows returned.

Use HAVING and WHERE Clauses in the Same Query (Visual Database Tools)
Explains how and why to use both of these clauses in a query.

Select Rows That Do Not Match a Value (Visual Database Tools)
Explains how to return all rows where the value of a give column does not match the value you provide in the query statement.

Include or Exclude Rows (Visual Database Tools)
Explains the concepts behind clauses and operators used in queries.

Exclude Duplicate Rows (Visual Database Tools)
Explains how to filter duplicate rows out of Select queries.

Combine Conditions When AND Has Precedence (Visual Database Tools)
Explains why and how to use the AND operator to filter query results.

Combine Conditions When OR Has Precedence (Visual Database Tools)
Explains why and how to use the OR operator to filter query results.

Create Subqueries (Visual Database Tools)
Explains how to create subqueries, or nested queries.

Perform Basic Operations with Queries (Visual Database Tools)
Provides links to topics with steps for the most common querying tasks.

Types of Queries (Visual Database Tools)
Provides links to topics explaining the supported query types.

Sort and Group Query Results (Visual Database Tools)
Provides links to topics with steps for sorting and grouping the results of a query.

Summarize Query Results (Visual Database Tools)
Provides links to topics with steps for summarizing results, including NULL and Nonnumeric columns.

Design Queries and Views How-to Topics (Visual Database Tools)
Provides links to topics and sections covering work you can do in queries and views using the Query and View Designer.