什么是确切的"SOME/ANY"?和"IN"表示

本文介绍了什么是确切的"SOME/ANY"?和"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:

technet.microsoft/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 */