在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;
在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;