关于查询数据时,添加一个自增序列号的列的问题点击打开链接
——————————————————————————————
自己在写接口的时候,需要从 日志表中捞取5个数据,另外再生成一个自增序列,例子如下:
如下是表格
MySql语句:
SELECT row_number()over(order by OLObjId) AS Id,
OLOperateTime AS OrderOperatime,
OLObjName AS OrderName,
OLObjOldValue AS Status,
OLObjNewValue AS StatusModify,
OLOperator AS OrderOperator
FROM AT_OperationLog
WHERE OLObjId = 300
ORDER BY OLOperateTime DESC