Teradata and MySQL behave different in OVER() and Partition By () Clauses
2
2
I want to understand why the same query is producing different result in Teradata and My SQL. I am trying to write a query for running total and each DB is giving me different solutions. Below is the code: CREATE TABLE runn_tot (p_id int, p_name varchar(10), price decimal(5,2)); insert into runn_tot values (1,'p1',34); insert into runn_tot values (2,'p1',56); insert into runn_tot values (3,'p1',65); insert into runn_tot values (4,'p1',12); insert into runn_tot values (5,'p1',34); insert into runn_tot values (6,'p1',78); insert into runn_tot values (7,'p1',23); insert into runn_tot values (8,'p1',55); insert into runn_tot values (9,'p1',34); insert into runn_tot values (10,'p1',66); The query which i'm using in Both ...
