SqlServer教程

SQLServer IN()

SQLServer IN条件用于避免SELECT,INSERT,UPDATE或DELETE语句中出现多个OR条件。
语法
expression IN (value1, value2, .... value_n); 

参数说明

表达式: 它指定要测试的值。
值1,值2、 value_n: 它指定要针对表达式测试的值。
注意: SQLServer IN条件也称为SQLServer IN运算符。

带有字符串值的IN条件

使用IN条件比较字符串值的SQLServer SELECT语句:
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE name IN ('Mahesh', 'Lily', 'Rahul'); 
输出:
SQLServer in 1
OR
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE name = 'Mahesh'
OR name = 'Lily'
OR name = 'Rahul';
输出:
SQLServer in 2

带有数字值的IN条件

使用IN条件比较数字值的SQLServer SELECT语句:
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id IN (14, 13, 9, 11, 10); 
输出:
SQLServer in 3
OR
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id = 14
OR id = 13
OR id = 9
OR id = 11
OR id = 10; 
输出:
SQLServer in 4

使用NOT运算符的IN条件

使用带有NOT运算符的IN条件的SQLServer SELECT语句:
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE name NOT IN ('Mahesh', 'Lily', 'Rahul'); 
输出:
SQLServer in 5
OR
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE name <> 'Mahesh'
AND  name <> 'Lily'
AND name <> 'Rahul';
输出:
SQLServer in 6
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4