Home  >  Article  >  Backend Development  >  Talk about the between_PHP tutorial on sql query

Talk about the between_PHP tutorial on sql query

WBOY
WBOYOriginal
2016-07-13 17:00:52812browse

Author: Ah Liang
Published in ASP Zone, 2000-11-25 21:42
Example 1: Find the student number and age of students between 20 and 22 years old (including 20 and 22)
select number,age
from s
where age between 20 and 22
Example 2: Find the student number and age of students who are not between 20 and 22 years old
select number,age
from s
where age not between 20 and 22
Note: between is followed by a low value, and is followed by a high value!

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631220.htmlTechArticleAuthor: Ah Liang Published in ASP Zone, 2000-11-25 21:42 Example 1: Find the age in 20 Select number,age from s where age betwe...
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