什么是确切的"SOME/ANY"?和"IN"表示 [英] What is exactly "SOME / ANY" and "IN"

问题描述

当有人通过"SOME"或"ANY"调用函数时，我对此一无所知.

When someone is calling a function by "SOME" or "ANY" makes me unsure about this.

我可以将"SOME"视为"OneOf"还是"OneFrom"吗?像数组(表)搜索功能一样?如果是，那么SOME和IN有什么区别?

Can I think about "SOME" as "OneOf" or "OneFrom"? Like an array (table) searching function? If yes, then what's the difference between SOME and IN?

我是使用SQL的新手

对不起，我的英语不好，出于某种原因，我认为我现在为正确使用它一点也不为过

Sorry for my bad english, for some reason I think I am little overtired to use it correctly now

推荐答案

在以下链接中查看一些示例，以阐明它们之间的区别:

Check the following link for some examples that should clarify the difference between them:

http://technet.microsoft.com/en-us/library/ms175064.aspx

IN 仅测试是否相等，而 ALL/ANY/SOME 可以针对任何比较运算符进行测试.

IN only tests for equality, while ALL/ANY/SOME can test against any of the comparison operators.

这是示例 SQL小提琴.

-- SQL 2012

CREATE TABLE T1 (ID int) ;

INSERT T1 VALUES (1) ;
INSERT T1 VALUES (2) ;
INSERT T1 VALUES (3) ;
INSERT T1 VALUES (4) ;

SELECT CASE WHEN 3 IN (SELECT id FROM t1) THEN 'in true' ELSE 'in false' END
UNION

SELECT CASE WHEN 3 < SOME (SELECT id FROM t1) THEN 'some true' ELSE 'some false' END
UNION

SELECT CASE WHEN 3 < ANY (SELECT id FROM t1) THEN 'any true' ELSE 'any false' END
UNION

SELECT CASE WHEN 3 < ALL (SELECT id FROM t1) THEN 'all true' ELSE 'all false' END;


/* Returns

all false
any true
in true
some true

*/

这篇关于什么是确切的"SOME/ANY"?和"IN"表示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！