difference between <> and !=
oracle, sql, sql-server
Solution
For SQL Server:
They are the same. Both are two Not Equal To operators. But `!=` is not ISO standard, as quoted from Comparison Operators:
<> (Not Equal To) Not equal to
!= (Not Equal To) Not equal to (not ISO standard)
Problem
Possible Duplicate: Oracle <> , != , ^= operators in sql, what is the difference between `<>` and `!=`, we can use both for "`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