This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › The difference between "!=" and "<>" in SQL statements
View: 8449|Reply: 0

[Source] The difference between "!=" and "<>" in SQL statements

[Copy link]
Posted on 6/17/2020 4:51:34 PM | | |
ANSI standards use <> (so <> is recommended), but in order to be consistent with most databases, databases generally provide != (high-level languages are generally used to express that is not equal to) and <> is not equal to:

  • MySQL 5.1: Supports != and <>
  • PostgreSQL 8.3: Supports != and <>
  • SQLite: 支持 != 和 <>
  • Oracle 10g: Supports != and <>
  • Microsoft SQL Server 2000/2005/2008: Supports != and <>
  • IBM Informix Dynamic Server 10: Supports != and <>
  • InterBase/Firebird: Supports != and <>

The last two databases only support ANSI standards:

  • IBM DB2 UDB 9.5: Only <> is supported
  • Apache Derby: Only <> is supported





Previous:Angular 9 series (VII) CSS-style scope
Next:More than one module matches. Use skip-import option to skip importing...

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com