mysql查询时，加入一个从1开始子增长的字段

mysql查询时，加入一个从1开始子增长的字段

SELECT ROW_NUMBER() OVER(ORDER BY a.SERIAL) AS row_num, 
       a.SERIAL, 
       a.COMMANDID, 
       a.CELLID, 
       a.USERID, 
       b.NAME, 
       c.ALIAS 
FROM system_command AS a 
JOIN system_index AS b ON a.CELLID = b.ID 
JOIN system_users AS c ON a.USERID = c.ID