Row_Number(SQL)no MYSQL

[Anderson dos reis 0]

Como usar parecido com o row_number(SQL SERVER) NO MYSQL?

EX.

 

SELECT 
(row_number() over (order by base)) AS ID,
substring(base,1,7) as Nome,
substring(base,8,2) as TipoDoRegistro,
substring(base,10,20) as Matrícula,
substring(base,30,70) as Plano,
substring(base,100,22)as NumeroDoCartao,
substring(base,122,2)+'/'+substring(base,124,2)+'/'+substring(base,126,4)as DataNascimento,
substring(base,130,96) as Boleto,
substring(base,226,10)as ValorTotalMensalidades,
substring(base,236,2)+'/'+substring(base,238,2)+'/'+substring(base,240,4)as DataLimitePagamento,
substring(base,244,10)as Sequencial,
substring(base,254,20)as ChaveOrigemRotina
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY base) id, base FROM  dbo.testebase
) TAB WHERE id % 2 > 0                                                                 
ORDER BY id

[Anderson dos reis 0]

11 horas atrás, Anderson dos reis disse:

Como usar parecido com o row_number,over e mod (SQL SERVER) NO MYSQL?

EX.

 

SELECT 
(row_number() over (order by base)) AS ID,
substring(base,1,7) as Nome,
substring(base,8,2) as TipoDoRegistro,
substring(base,10,20) as Matrícula,
substring(base,30,70) as Plano,
substring(base,100,22)as NumeroDoCartao,
substring(base,122,2)+'/'+substring(base,124,2)+'/'+substring(base,126,4)as DataNascimento,
substring(base,130,96) as Boleto,
substring(base,226,10)as ValorTotalMensalidades,
substring(base,236,2)+'/'+substring(base,238,2)+'/'+substring(base,240,4)as DataLimitePagamento,
substring(base,244,10)as Sequencial,
substring(base,254,20)as ChaveOrigemRotina
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY base) id, base FROM  dbo.testebase
) TAB WHERE id % 2 > 0                                                                 
ORDER BY id