Home >Database >Mysql Tutorial >sql中all,any,some用法
sql中all,any,some用法
- WBOYOriginal
- 2016-06-07 17:59:151996browse
sql中all,any,some用法实现语句，需要的朋友可以看下。
--All：对所有数据都满足条件，整个条件才成立，例如：5大于所有返回的idselect *
from #A
where 5>All(select id from #A)
go
--Any：只要有一条数据满足条件，整个条件成立，例如：3大于1，2
select *
from #A
where 3>any(select id from #A)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：跨服务器查询导入数据的sql语句Next article：返回SQL执行时间的存储过程