Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @counter = 0;
- SELECT (@counter := @counter + 1) AS NP, name, email FROM profiles;
- +------+--------------+------------------+
- | NP | name | email |
- +------+--------------+------------------+
- | 1 | dfsdfsf | dsfdsfsf |
- | 2 | alfa | mail@mail.com |
- | 3 | danielo | mail@mail.com |
- | 4 | ortega oga | mail@mail.com |
- | 5 | diana | mail@mail.com |
- | 6 | elena | mail@mail.com |
- | 7 | gonzalo | mail@mail.com |
- | 8 | jorge | mail@mail.com |
- | 9 | mendez | mail@mail.com |
- | 10 | pedro | mail@mail.com |
- | 11 | arnoldo | mail@mail.com |
- +------+--------------+------------------+
- SELECT row_number() OVER (ORDER BY name) AS NP, name, email
- FROM profiles;
- +------+--------------+------------------+
- | NP | name | email |
- +------+--------------+------------------+
- | 1 | dfsdfsf | dsfdsfsf |
- | 2 | alfa | mail@mail.com |
- | 3 | danielo | mail@mail.com |
- | 4 | ortega oga | mail@mail.com |
- | 5 | diana | mail@mail.com |
- | 6 | elena | mail@mail.com |
- | 7 | gonzalo | mail@mail.com |
- | 8 | jorge | mail@mail.com |
- | 9 | mendez | mail@mail.com |
- | 10 | pedro | mail@mail.com |
- | 11 | arnoldo | mail@mail.com |
- +------+--------------+------------------+
Add Comment
Please, Sign In to add comment