SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE transacoes ( usuario_origem INT NOT NULL, usuario_destino INT NOT NULL, data_transacao datetime, montante FLOAT ); INSERT INTO transacoes (usuario_origem, usuario_destino, data_transacao, montante) VALUES (1, 5, CAST('2022-01-02' AS date), 124.00), (2, 5, CAST('2022-01-02' AS date), 23.00), (5, 1, CAST('2022-01-02' AS date), 55.15), (3, 2, CAST('2022-01-05' AS date), 44.50), (3, 2, CAST('2022-01-15' AS date), 12.00), (4, 1, CAST('2022-01-15' AS date), 44.10), (3, 4, CAST('2022-01-18' AS date), 50.00), (1, 2, CAST('2022-01-20' AS date), 150.10), (5, 2, CAST('2022-01-21' AS date), 500.10), (3, 1, CAST('2022-01-21' AS date), 20.10), (1, 5, CAST('2022-01-30' AS date), 40.50), (4, 1, CAST('2022-01-31' AS date), 999.00); SELECT ROW_NUMBER() OVER(PARTITION BY usuario_origem ORDER BY data_transacao ASC) as num_row, id, modelo FROM transacoes WHERE id > 2
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear