sql 数据库 mysql mssql oracle 合集

add

分页 大型数据 超快方法 sql
pageRow : 每页显示数量
pages : 总页数

[SQL] 纯文本查看 复制代码

select * from (select top 10 * form (select top 1000*10 * from xx order by id desc) order by id) order by id
select * from (select top 10 * form (select top 999*10 * from xx order by id desc) order by id) order by id
select * from (select top 10 * form (select top 998*10 * from xx order by id desc) order by id) order by id
select * from (select top 10 * form (select top 9 * from xx order by id desc) order by id) order by id

select code,case when code in (201,207) then "成功" when code=202 then "成都1" else "失败" end code1 from student_business

add

UPDATE jzfp_pkh_pkh p set p.JTZZ=CONCAT('某某乡某某村',substring(p.JTZZ,-2))