在mysql、或hive中查询时需要自己构建一个自增序列时可参照以下语法:
set @rownum=0;
select @rownum:=@rownum+1 as id from dual;
set @rownum=0;
SELECT @rownum:=@rownum+1 AS rownum
FROM dual
limit 10;
SET @rownum =0;
SELECT *,@rownum := @rownum +1 as seq from ss;
一起执行!
或者:select ss.* ,(@i:=@i+1) as seq from ss,(select @i:=0) as it 也可以达到通用效果
MySQL查询结果另外自带一列自增序列号
最新推荐文章于 2023-09-11 16:52:42 发布