SQL 查询问题

WBOY
WBOYOriginal
2016-06-23 13:36:21928browse

比如,数据表中有r4字段,内容是 
a0010b
a0020b
a0030b
a0040b

现在要按范围查询,a0020b到a0040b 之间的内容

表单:请填写最小单号_____请填写最大单号_____

查询语句怎么写?
谢谢


回复讨论(解决方案)

where r4>=a0020b and r4

有没有人会?

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