mysql分页排序带参数
来源:互联网 发布:linux 修改文件时间戳 编辑:程序博客网 时间:2024/05/19 14:52
http://www.dewen.io/q/4248
select empid,deptid,rank from (
select c.empid,c.deptid,
if(@pdept=c.deptid,@rank:=@rank+1,@rank:=1) as rank,
@pdept:=c.deptid
from (
select catid AS empid,siteid as deptid from v9_category
) c ,(select @pdept := null ,@rank:=0) a ) result
SELECT empid,deptid,salary,rank FROM
(SELECT *,@rownum:=@rownum+1 AS rownum,IF(@pa=ff.deptid,@rank:=@rank+1,@rank:=1) AS rank,@pa:=ff.deptid
FROM
(SELECT empid,deptid,salary FROM employee GROUP BY deptid,salary ORDER BY deptid ASC, salary DESC) ff,(SELECT @rank:=0,@rownum:=0,@pa=NULL) tt) result
这个可以:行号和排序序号都有:
select * from (
select c.empid,c.deptid,@rownum:=@rownum+1 AS rownum,
-- if(@pdept=c.deptid,@rank:=@rank+1,@rank:=1) as rank,@pdept:=c.deptid 相同不并列
if(@pdept=c.deptid,@rank:=@rank,@rank:=@rank+1) as rank,@pdept:=c.deptid -- 相同的并列排序
from (
-- select catid AS empid,siteid as deptid from v9_category
SELECT n.id empid, n.catid deptid,c.catname FROM v9_news n JOIN v9_category c ON c.catid=n.catid -- LIMIT 1,15
) c ,(select @pdept := null ,@rank:=0,@rownum:=0) a ) result
select empid,deptid,rank from (
select c.empid,c.deptid,
if(@pdept=c.deptid,@rank:=@rank+1,@rank:=1) as rank,
@pdept:=c.deptid
from (
select catid AS empid,siteid as deptid from v9_category
) c ,(select @pdept := null ,@rank:=0) a ) result
SELECT empid,deptid,salary,rank FROM
(SELECT *,@rownum:=@rownum+1 AS rownum,IF(@pa=ff.deptid,@rank:=@rank+1,@rank:=1) AS rank,@pa:=ff.deptid
FROM
(SELECT empid,deptid,salary FROM employee GROUP BY deptid,salary ORDER BY deptid ASC, salary DESC) ff,(SELECT @rank:=0,@rownum:=0,@pa=NULL) tt) result
这个可以:行号和排序序号都有:
select * from (
select c.empid,c.deptid,@rownum:=@rownum+1 AS rownum,
-- if(@pdept=c.deptid,@rank:=@rank+1,@rank:=1) as rank,@pdept:=c.deptid 相同不并列
if(@pdept=c.deptid,@rank:=@rank,@rank:=@rank+1) as rank,@pdept:=c.deptid -- 相同的并列排序
from (
-- select catid AS empid,siteid as deptid from v9_category
SELECT n.id empid, n.catid deptid,c.catname FROM v9_news n JOIN v9_category c ON c.catid=n.catid -- LIMIT 1,15
) c ,(select @pdept := null ,@rank:=0,@rownum:=0) a ) result
0 0
- mysql分页排序带参数
- laravel中分页带参数
- laravel 搜索分页 带参数稳定分页
- mysql 分页排序
- JSTL带参数查询分页方法
- sql2005带参数的分页存储过程
- ExtJs4 bbar分页带参数查询
- JdbcTemplate带参数的分页查询
- thinkphp5 分页带参数的解决办法
- 带排序的oracle分页存储过程
- 带排序的oracle分页存储过程
- **GridView**自带的分页和排序
- 带排序的oracle分页存储过程
- 带排序的oracle分页存储过程
- mysql 带参数的游标
- laravel原生分页并带参数的搜索分页
- MySQL数据库limit分页、排序
- mysql分页和排序练习
- 1043. Is It a Binary Search Tree (25)
- 将来如果我学过一门便会删掉里面相关的文章(立个小目标嘛哈哈哈)
- OGRE学习系列三:基础教程1 你的第一个场景
- 476. Number Complement
- 在Linux机器上部署UOJ评测系统
- mysql分页排序带参数
- JSONP跨域获取JSON数据(含jQuery方法)
- [快速幂]XDOJ-Problem E Hanoi Tower
- js实现搜索表格内数据
- JSP
- 设计模式--策略模式
- .net MVC框架下利用css+js实现遮罩效果
- my presentation2
- OpenGL 的空间变换(上):矩阵在空间几何中的应用