By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.36 |
CREATE TABLE users
(id INT,
name VARCHAR(50));
INSERT INTO users VALUES
(1,'sdgfafa'),
(8,'jhkjhlhjl'),
(5,'erertrz'),
(7,'cvcvnvcn'),
(2,'qweqwe'),
(9,'iopoipi');
CREATE temporary TABLE aa AS (SELECT * FROM users limit 3);
CREATE temporary TABLE bb AS (SELECT * FROM users limit 3,3);
Records: 6 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
SELECT * FROM users
| id | name |
|---|---|
| 1 | sdgfafa |
| 8 | jhkjhlhjl |
| 5 | erertrz |
| 7 | cvcvnvcn |
| 2 | qweqwe |
| 9 | iopoipi |
SELECT * FROM aa;
SELECT * FROM bb;
| id | name |
|---|---|
| 1 | sdgfafa |
| 8 | jhkjhlhjl |
| 5 | erertrz |
| id | name |
|---|---|
| 7 | cvcvnvcn |
| 2 | qweqwe |
| 9 | iopoipi |
select row_number() over () ra, aa.* from aa
| ra | id | name |
|---|---|---|
| 1 | 1 | sdgfafa |
| 2 | 8 | jhkjhlhjl |
| 3 | 5 | erertrz |
select row_number() over () rb, bb.* from bb
| rb | id | name |
|---|---|---|
| 1 | 7 | cvcvnvcn |
| 2 | 2 | qweqwe |
| 3 | 9 | iopoipi |
select aa.id, aa.name, bb.id, bb.name
from (select row_number() over () ra, aa.* from aa) aa
join (select row_number() over () rb, bb.* from bb) bb on ra=rb
| id | name | id | name |
|---|---|---|---|
| 1 | sdgfafa | 7 | cvcvnvcn |
| 8 | jhkjhlhjl | 2 | qweqwe |
| 5 | erertrz | 9 | iopoipi |