diff options
Diffstat (limited to 'mysql-test/main/win_percent_cume.test')
-rw-r--r-- | mysql-test/main/win_percent_cume.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/win_percent_cume.test b/mysql-test/main/win_percent_cume.test index b851185cb32..05ace95d571 100644 --- a/mysql-test/main/win_percent_cume.test +++ b/mysql-test/main/win_percent_cume.test @@ -17,17 +17,17 @@ insert into t1 values ( 9 , 4, 20), (10 , 4, 20); -select pk, a, b, +select a, percent_rank() over (order by a), cume_dist() over (order by a) from t1; -select pk, a, b, +select pk, percent_rank() over (order by pk), cume_dist() over (order by pk) from t1 order by pk; -select pk, a, b, +select a, percent_rank() over (partition by a order by a), cume_dist() over (partition by a order by a) from t1; |