初始化表結(jié)構(gòu)

DROP TABLE IF EXISTS `data`;

CREATE TABLE `data` (

`dates` varchar(255) CHARACTER SET utf8 DEFAULT NULL,

`id` int(11) DEFAULT NULL,

`result` varchar(255) CHARACTER SET utf8 DEFAULT NULL

);

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015109101', 1, '勝');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015110101', 2, '負');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015109101', 3, '負');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015109101', 4, '勝');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015110101', 5, '勝');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015109101', 6, '負');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015109101', 7, '勝');

INSERT INTO `data` (`dates`, `id`, `result`) VALUES ('2015110101', 8, '負');

排序

select @rownum:=@rownum+1 AS rownum,id,dates

from

`data`,(SELECT @rownum:=0) r

ORDER BY dates;

結(jié)果

條件查詢

SELECT rownum,id

from

(select @rownum:=@rownum+1 AS rownum,id,dates

from

`data`,(SELECT @rownum:=0) r

ORDER BY dates)b

WHERE id =2;

結(jié)果

總結(jié)

以上是生活随笔為你收集整理的mysql排序时设置主次_Mysql实现Rownum()排序后根据条件获取名次的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。