~~~~~~~~怎样查询某一段范围内的值~~~~~~~~~谢谢!

[wendi]

比如现在有一个表
----------------------
col1 col2 .....
-----------------------
abc001
abc002
....
....
abc999

怎样把 abc500到abc800的值查询出来???

[冷箫轻笛]

select * from tablename
where col1 between 'abc500' and 'abc800'

[LouisXIV]

怎样把 abc500到abc800的值查询出来???

-------------------

select * from tablename where col between 'abc500' and 'abc800'