![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
不是我的货
开始写博客,开始输出我知道的东西
展开
-
utf-8 UTF-8 和utf8 区别
utf-8和UTF-8的区别: 在页面或者在ajax中设置编码,请尽量统一写成“UTF-8”,而utf-8只是在window中不区分大小写的写法而已,其次,大部分情况简写成“UTF8”或“utf8”程序也可以识别,但在ie浏览器就不识别它了,所以,最好,严格写成“UTF-8”,比如: ServletActionContext.getResponse().setContentType(原创 2015-04-16 16:05:47 · 1928 阅读 · 0 评论 -
各种分页语句
1hibernate的hql的分页语句:原创 2015-04-14 18:26:04 · 471 阅读 · 0 评论 -
sql汇总
========================高级查询======== select count(1) from emp; select count(distinct job) from emp; select sal,job from emp where sal=(select max(sal) from emp); select job ,count(job) from emp gr原创 2015-07-18 12:04:16 · 276 阅读 · 0 评论 -
分段函数,列转行
SELECT sum(CASE when score60 then 1 else 0 end) AS '不及格', sum(CASE when score>=60 and score70 then 1 else 0 end) AS '差', sum(CASE when score>=70 and score80 then 1 else 0 end) AS原创 2015-08-19 06:12:33 · 393 阅读 · 0 评论 -
oracle 分页 sql
原有sql(查询所有数据): SELECT c. ID, A . NAME AS NAME, A .define_sql AS defineSql, A .use_scene AS useScene , A.config_kind AS configKind, c.examine_status AS...原创 2018-10-30 11:35:17 · 176 阅读 · 0 评论