Oracle及MS-SQL都有RowNumber的語法可用
MySQL則需要使用一些技巧
1 2 3 4 5 6 | select x.id,x.val,x.seq, @i := @i + 1 as row_number from ( select 222 as seq,'row1' as id,'value1' as val from dual union all select 111 as seq,'row2' as id,'value2' as val from dual ) x,(select @i := 0) temp order by x.seq; |
資料
加了Rownumber後
如果只是要做分頁效果則使用
limit Start_Row,Page Of Row
limit 10,20