0 out of 1 rated this helpful - Rate this topic

Specifying Search Criteria (Visual Database Tools)

SQL Server 2008

Other Versions

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.
How to: Specify Search Conditions (Visual Database Tools): Explains the basics of choosing search criteria to get just the data you want.
How to: Specify Multiple Search Conditions for One Column (Visual Database Tools): Explains how to create multiple search conditions to the same data column.
How to: 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.
How to: Specify the TOP Clause in Queries (Visual Database Tools): Explains how to have only a given number or percentage of rows returned.
How to: 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.
How to: 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.
How to: Include or Exclude Rows (Visual Database Tools): Explains the concepts behind clauses and operators used in queries.
How to: Exclude Duplicate Rows (Visual Database Tools): Explains how to filter duplicate rows out of Select queries.
How to: Combine Conditions When AND Has Precedence (Visual Database Tools): Explains why and how to use the AND operator to filter query results.
How to: Combine Conditions When OR Has Precedence (Visual Database Tools): Explains why and how to use the OR operator to filter query results.
How to: Create Subqueries (Visual Database Tools): Explains how to create subqueries, or nested queries.

Related Sections

Performing 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.
Sorting and Grouping Query Results (Visual Database Tools): Provides links to topics with steps for sorting and grouping the results of a query.
Summarizing Query Results (Visual Database Tools): Provides links to topics with steps for summarizing results, including NULL and Nonnumeric columns.
Designing 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD