Logical Operators (Transact-SQL)
2024-10-01 12:48:55
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/logical-operators-transact-sql
Logical operators test for the truth of some condition. Logical operators, like comparison operators, return a Boolean data type with a value of TRUE, FALSE, or UNKNOWN.
Operator | Meaning |
---|---|
ALL | TRUE if all of a set of comparisons are TRUE. |
AND | TRUE if both Boolean expressions are TRUE. |
ANY | TRUE if any one of a set of comparisons are TRUE. |
BETWEEN | TRUE if the operand is within a range. |
EXISTS | TRUE if a subquery contains any rows. |
IN | TRUE if the operand is equal to one of a list of expressions. |
LIKE | TRUE if the operand matches a pattern. |
NOT | Reverses the value of any other Boolean operator. |
OR | TRUE if either Boolean expression is TRUE. |
SOME | TRUE if some of a set of comparisons are TRUE. |
最新文章
- Redis事件管理(三)
- 用xib自定义UITableViewCell
- NET4.5之初识async与await
- oracle--clob
- 防止服务器宕机时MySQL数据丢失的几种方案
- C#中foreach遍历学习笔记
- HDU 2451 Simple Addition Expression(组合数学)
- bat(批处理文件)初步 第一篇 基本符号
- Linux基础正则表达式:grep,sed
- poj2513- Colored Sticks 字典树+欧拉通路判断
- springboot 入门四-时间类型处理
- 牛客网编程练习之PAT乙级(Basic Level):1033 害死人不偿命的(3n+1)猜想
- Kubernetes1.7—DNS安装
- Nhibernate 使用 (一)
- codeforces 985B Switches and Lamps
- redhat7.2安全基线BI
- 【Java】 剑指offer(9) 斐波那契数列及青蛙跳台阶问题
- nodejs安装、环境配置和测试
- 转 linux常用查看硬件设备信息命令
- php 区分0和空
热门文章
- Linux下MySql数据库常用操作
- org.apache.hadoop.ipc.Client: Retrying connect to server
- ASP.NET-常用正则表达式
- C#-入门思维导图
- [Ubuntu]安装中文输入法
- jQuery——map()函数以及它的java实现
- java大数类,两个不超过20位都不为0的十进制字符串相乘,华为笔试题
- zzulioj--1711--漂洋过海来看你(dfs+vector)
- javascript系列-class4.函数
- Binary Indexed Tree