Shulou(Shulou.com)06/01 Report--

This article mainly explains "SQL sentence is not equal to how to write", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "SQL sentence is not equal to how to write" it!

There are three kinds of expressions that are not equal in Oracle:,! =, ^ =, but only the formal SQL syntax is used in the above three expressions, and the other two ways are relatively poor in compatibility.

Many friends are accustomed to using! = to express it, but only if it is suitable for all versions of SQL, it will report errors in older versions of SQL, such as the SQL2000 version.

Example: query data that is not equal to 200

SELECT * FROM T_TABLE WHERE COL is null OR COL '200' so far, I believe you have a deeper understanding of "SQL sentences are not equal to how to write". You might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.