blocks|key|2502067|text|a+%25+2+=+0+here+%25+as+Modulus算术运算符。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2502068|语法：dividend+%25+divisor|2502069|示例：SELECT+15+%25+2+AS+Remainder它将以1的形式返回结果|2502070|2502071|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-2017^0|0|9|F|1|K|7|0|0|3|I|0|3|Q|W|1|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|F|3|G|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|13|8|@$9|14|A|15|B|C]|$9|16|A|17|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|18|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

<code>a % 2 = 0</code> here <code>%</code> as <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">Modulus</a> arithmetic operator.

Syntax: <code>dividend % divisor</code>

Sample: <code>SELECT 15 % 2 AS Remainder</code> it will return the result as <code>1</code>

<a href="https://dbfiddle.uk/?rdbms=sqlserver_2017&amp;fiddle=edd22777a18633b04d24795cbdb5c1f1" rel="nofollow noreferrer">Demo on db&lt;>fiddle</a>

blocks|key|2289700|text|当在字符串外部使用时，百分号%25是modulus+operator，即一个运算符，它返回前一个运算符的数字除以后一个运算符的余数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2289701|因此，在您的示例中，如果百分比符号前面的数字是偶数，则将验证表达式%25+2+=+0，例如，12+%25+2+=+0将返回True。|2289702|然而，当在like表达式的模式参数中使用时，百分比符号表示匹配任何字符序列(或者根本没有字符)的通配符运算符。|2289703|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-2017|1|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-2017^0|E|1|G|G|0|0|X|7|18|A|1L|4|0|5|4|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@$9|W|A|X|1|Y]]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|J|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]|R|$5|M|N|O|E|$P|S]]]]

When used outside of a string, the percentage symbol <code>%</code> is the <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">modulus operator</a>, i.e. an operator which returns the remainder following division of the number preceding the operator by that following it. 

Therefore, in your example, the expression <code>% 2 = 0</code> will be validated if the number preceding the percentage symbol is even, e.g. <code>12 % 2 = 0</code> will return <code>True</code>.

Whereas, when used in the pattern argument of a <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">like</a> expression, the percentage symbol represents a wildcard operator matching any sequence of characters (or no characters at all).

blocks|key|2289720|text|让我们通过一个例子来理解：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2289721|我已经创建了一个表名-+'c'，它包含两个属性'+name‘和'num’。|2289722|当计算num%2510时，例如55%2510，->会得到5。|2289723|如果结果为2或7，则不会打印该行|2289724|如果Elseif+result+(num%2510)不是2或7，那么在本例中它将打印该行。|2289725|现在：|2289726|Select+*from+c+where+num%2510+NOT+In(2,7);++|code-block|syntax|javascript|2289727|点击此处查看截图:enter+image+description+here|offset|length|2289728|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/Sxld6.png^0|0|0|0|0|0|0|0|9|S|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|18|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|19|8|@]|9|@$S|1A|T|1B|1|1C]]|A|$]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

Let's understand with an example: 
I have created an Table name - 'c', which contain 2 attribute 'name' and 'num'.

when num%10 is calculated e.g. 55%10 -> gives 5. 
If result is either 2 or 7 then it will not print that row 
Elseif result (num%10) is NOT 2 or 7 then in this case it will print the row.

Now:

<pre><code>Select *from c where num%10 NOT In(2,7); 
</code></pre>

Check out Screenshot here :<a href="https://i.stack.imgur.com/Sxld6.png" rel="nofollow noreferrer">enter image description here</a>

Could someone explain the difference between <code>%</code> in SQL? 

I understand that <code>%</code> is a wildcard that allows you to query results with <code>LIKE</code> results, i.e. <code>a%</code> for words starting with a, but I am confused why the wildcard can be used as <code>% 2 = 0</code> to query for even numbers? 

I saw an explanation that said <code>%</code> can be used as divide but I thought <code>/</code> was divide.

Explanation of % in SQL

有人能解释一下SQL中%的区别吗？我知道%是一个通配符，它允许您使用LIKE结果查询结果，即a%查询以a开头的单词，但我不明白为什么通配符可以用作查询偶数的% 2 = 0？我看到一个解释，说%可以用作divide，但我认为/是divide。

问SQL中%的解释
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中%的解释EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中%的解释
EN