in和SQL中的任何运算符之间的区别 [英] Difference between in and any operators in sql

问题描述

SQL中的IN和ANY运算符之间有什么区别?

What is the difference between IN and ANY operators in SQL ?

推荐答案

SQL>
SQL> -- Use the ANY operator in a WHERE clause to compare a value with any of the values in a list.
SQL>

SQL>-您必须在ANY之前放置=，<>，<，>，< =或> =运算符.

SQL> SELECT *
  2  FROM employee
  3  WHERE salary > ANY (2000, 3000, 4000);

对于In运算符

SQL> -- Use the IN operator in a WHERE clause to compare a value with any of the values in a list.
SQL> SELECT *
  2  FROM employee
  3  WHERE salary IN (2000, 3000, 4000);

但是对于IN运算符，您不能使用=，<>，<，>，< =或> =

这篇关于in和SQL中的任何运算符之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！