想查询ID字为88到788的所有字段条件怎么写？

[Caobiao]

请问想查询ID字为88到788的所有字段条件怎么写？谢谢

[mislrb]

id>=88 and id<=788

id between 88 and 788

[-狙击手-]

要是ID是char ,还得转换

[rishengw]

select * from 表 where ID between 88 and 788

[yingfeiqiyue]

Caobiao (Caobiao)
我来接分！

[ReViSion]

给分哦
select * from 表 where ID between 88 and 788

[lw1a2]

select * from 表 where ID between 88 and 788

[子陌红尘]

select * from 表 where ID between 88 and 788

[OracleRoob]

select * from 表名 where ID between 88 and 788

或

select * from 表名 where ID >= 88 and ID <= 788

[zhaoanle]

select * from 表 where ID between 88 and 788

[zlp321002]

Between

[liujx_1999]

select * from 表 where ID between 88 and 788