MySQL 行号(类似SQLServer的row_number())

Select ID,(@rowNum:=@rowNum+1) as RowNo From a,(Select (@rowNum :=0) ) b

posted @ 2015-05-22 15:26  帕丁顿熊  阅读(1053)  评论(0)    收藏  举报