Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @contador := 0;
- SELECT
- @contador := @contador + 1 AS linha,
- t.campo1,
- t.campo2
- FROM
- tabela t
- SELECT
- @contador := @contador + 1 AS linha,
- t.campo1,
- t.campo2
- FROM
- (SELECT @contador := 0) AS nada,
- tabela t
- SELECT
- @contador := @contador + 1 AS linha,
- t.campo1,
- t.campo2
- FROM
- (SELECT @contador := 0) AS nada,
- (SELECT SUM(campo) FROM tabela GROUP BY algumacoisa JOIN outracoisa ... ) AS t
- SELECT
- ROW_NUMBER() OVER (ORDER BY campo1),
- t.campo1,
- t.campo2
- FROM
- tabela t
- SELECT
- ROWNUM,
- t.campo1,
- t.campo2
- FROM
- tabela t
Add Comment
Please, Sign In to add comment