yambejp score 69726
2017/06/02 20:54 投稿
| 見た感じ、なにかのランク付けじゃないですか？ |
| id順に連番をつけているとか？ |
| id順に連番をつけているとか？ |
| # sample |
| ```SQL |
| create table tbl(id int not null unique,val int); |
| insert into tbl values(5,1),(7,2),(3,3),(1,4),(8,5); |
| ``` |
| ```SQL |
| select (select count(*)+1 from tbl as t2 where t2.id<t1.id) as rank,id,val |
| from tbl as t1 order by rank; |
| ``` |
