oracle <> 和 != 之间的区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13740732/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
difference between <> and !=
提问by Ravindra Bagale
Possible Duplicate:
Oracle <> , != , ^= operators
in sql, what is the difference between <>and !=, we can use both for "NOt Equal to".
在SQL中，是什么样的区别<>和!=，我们可以同时使用了“ NOt Equal to”。
is there any difference in between them?
ex.
它们之间有什么区别吗？
前任。
select * from student where no != 2;
&
&
select * from student where no <> 2;
is any advantage of using one insted of another?
使用一个插入另一个有什么好处吗？
What are the main factors because of which !=is not made as ISO standard
!=未按 ISO 标准制定的主要因素是什么
回答by Mahmoud Gamal
For SQL Server:
对于 SQL Server：
They are the same. Both are two Not Equal Tooperators. But !=is not ISO standard, as quoted from Comparison Operators:
他们是一样的。两者都是两个Not Equal To运算符。但!=不是 ISO 标准，引用自比较运算符：
<> (Not Equal To) Not equal to
!= (Not Equal To) Not equal to (not ISO standard)
<>（不等于）不等于
!=（不等于）不等于（非 ISO 标准）
