SOME | ANY (SQL Server Compact)

  • 發行項

比較純量值與單一資料行的值集合。

語法

scalar_expression { = | < > | ! = | > | > = | ! > | < | < = | ! < } 
   { SOME | ANY } (subquery )

引數

  • scalar_expression
    MicrosoftSQL Server Compact 中任何有效的運算式。

  • { = | <> | != | > | >= | !> | < | <= | !< }
    任何有效的比較運算子。

  • SOME | ANY
    指定應該進行比較。

  • subquery
    具有一個資料行的結果集的子查詢。傳回資料行的資料類型必須與 scalar_expression 的資料類型相同。

結果類型

bit

傳回值

當 ANY 配對 (scalar_expression、x) 指定的比較是 TRUE 時 (其中的 x 是單一資料行集的值)，SOME 或 ANY 會傳回 TRUE；否則就傳回 FALSE。

範例

ONE 只能搭配 SOME 或 ANY 引數使用。

-- This example queries for Employee ID values greater than 13.
-- The query locates some matching values,
-- a result of True is returned, with a list of the
-- matching Employee records.
SELECT *
FROM Employees
WHERE (0 < ANY
      (SELECT [Employee ID]
      FROM Employees AS Employees_1
      WHERE ([Employee ID] > 13)));

-- This example queries for Employee ID values greater than 15.
-- Because no matching values are found, a result of False is
-- returned and no records are displayed.
SELECT *
FROM Employees
WHERE (0 < ANY
      (SELECT [Employee ID]
      FROM Employees AS Employees_1
      WHERE ([Employee ID] > 15)));