You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-08-07 03:22:57 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
28 lines
868 B
Plaintext
28 lines
868 B
Plaintext
USE tpch1;
|
|
select depname, empno, moda(salary) over(partition by depname order by enroll_date) from empsalary order by depname, empno, enroll_date;
|
|
depname empno moda(salary) over(partition by depname order by enroll_date)
|
|
develop 7 5200
|
|
develop 8 6000
|
|
develop 9 5200
|
|
develop 10 5200
|
|
develop 11 5200
|
|
develop 12 5200
|
|
personnel 2 3900
|
|
personnel 5 3500
|
|
sales 1 5000
|
|
sales 3 4800
|
|
sales 4 4800
|
|
select avg(salary),depname, moda(salary) over(partition by depname order by enroll_date) from empsalary group by depname order by depname, avg(salary);
|
|
avg(salary) depname moda(salary) over(partition by depname order by enroll_date)
|
|
NULL develop 5200
|
|
4200.0000 develop 5200
|
|
4500.0000 develop 5200
|
|
5200.0000 develop 5200
|
|
5200.0000 develop 5200
|
|
6000.0000 develop 6000
|
|
3500.0000 personnel 3500
|
|
3900.0000 personnel 3900
|
|
4800.0000 sales 4800
|
|
4800.0000 sales 4800
|
|
5000.0000 sales 5000
|