社区 › 电脑业界 › sql 数据库 mysql mssql oracle 合集

amk 发表于 2015-12-16 01:15:51

sql 数据库 mysql mssql oracle 合集

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

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

amk 发表于 2017-6-19 10:56:59

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

查看完整版本: sql 数据库 mysql mssql oracle 合集