IN

The IN operator may be used if you know the exact value you want to return for at least one of the columns.
当你知道某栏目的准确值并想要返回其数据行，你可以使用IN操作符

SELECT column_name FROM table_name WHERE column_name IN (value1,value2,..)

Original Table (used in the examples)
初始表

举例 1

To display the persons with LastName equal to "Hansen" or "Pettersen", use the following SQL:
要显示LastName为"Hansen"或是"Pettersen"的记录，则可以使用下面的这条SQL语句：

SELECT * FROM Persons
WHERE LastName IN ('Hansen','Pettersen')

结果：

SQL Create View

评论 (0) All