Pesquisar na Comunidade
Mostrando resultados para as tags ''row_number''.
Encontrado 1 registro
-
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
