SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE transacoes ( id INT NOT NULL, usuario_destino INT NOT NULL, data_transacao datetime, soma_transacao INT ); INSERT INTO transacoes (id, usuario_destino, data_transacao, soma_transacao) VALUES (3, 5, CAST('2022-01-02' AS date), 5), (5, 5, CAST('2022-01-02' AS date), 10), (4, 1, CAST('2022-01-02' AS date), 8), (1, 2, CAST('2022-01-05' AS date), 3), (2, 2, CAST('2022-01-15' AS date), 2); SELECT ROW_NUMBER()OVER(PARTITION BY id ORDER BY data_transacao) as num_coluna FROM transacoes
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear