清风吹过脸庞

## # SELECT语法```sqlselect *|{[distinct]列|表达式[[as] 列别名],...}from[where 条件][order by 列|列别名|表达式|序号[ASC|DESC],...]```- ASC升序;DESC降序- 默认升序- 默认NULL值最大...

分页Oracle分页一般写法select * from ( select rownum rn,a.* from ( select * from table_name ) a where rownum <= 25) where rn >= 1最内层的select * from table_name是不经过分页的原...

看一下代码：<if test="rangeStart != null and rangeStart != ''"> and (LENGTH(t.column) = LENGTH(REGEXP_REPLACE(t.column, '[^0-9]')) and REGEXP_REPLACE(t.column, '[^0-9]') >=#{rangeStart})&l...