The operators you can use in a search condition : Query Select « Query « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Query
  3. Query Select
Operator      Description
!=            not equal
!>            not greater than
!<            not less than
<             less than
<=            less than or equal
<>            not being equal
=             equality between two expressions
>             greater than
>=            greater than or equal to
ALL           In subquery, if all retrieved values satisfy the search condition, the rows will be retrieved.
ANY           In subquery, if any retrieved values satisfy the search condition, the rows will be retrieved.
BETWEEN       Designates an inclusive range of values. Used with the AND clause between the beginning and ending values.
CONTAINS      Does a search for words and phrases.
ESCAPE        Escape from the pattern.
EXISTS        When used with a subquery, EXISTS tests for the existence of rows in the subquery.
FREETEXT      Searches character-based data for words using meaning, rather than literal values.
IN            Provides an inclusive list of values for the search condition.
IS NOT NULL   if the value is NOT null.
IS NULL       whether the value is null.
LIKE          pattern matching.
NOT BETWEEN   Specifies a range of values NOT to include.
NOT IN        Provides a list of values for which NOT to return rows for.
NOT LIKE      Tests character string, excluding those with pattern matches.
SOME          If any retrieved values satisfy the search condition, the rows will be retrieved.








1.1.Query Select
1.1.1.The basic syntax of the SELECT statement
1.1.2.The operators you can use in a search condition
1.1.3.Both uppercase and lowercase statements are acceptable, a query could be written as follows:
1.1.4.Operator Precedence
1.1.5.asterisk (*) specifies all columns of the named tables in the FROM clause
1.1.6.A SELECT statement that retrieves rows with non-zero values
1.1.7.A SELECT statement that retrieves two columns and a calculated value for a specific Billing
1.1.8.retrieve specific columns
1.1.9.A SELECT statement that retrieves three columns from each row, sorted in descending sequence by Billing total
1.1.10.A SELECT statement that returns an empty result set
1.1.11.SELECT 1.0 + 3.0 / 4.0 -- Returns 1.75
1.1.12.SELECT (1.0 + 3.0) / 4.0 -- Returns 1.00
1.1.13.The specification column_name [as] column_heading
1.1.14.Table alias
1.1.15.add a WHERE clause and group by
1.1.16.A SELECT statement that uses the CHAR function to format output
1.1.17.Use local variable in a select statement
1.1.18.Using SELECT to Create a Script