1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-08-07 03:22:57 +03:00
Files

10 lines
292 B
Plaintext

USE tpch1;
select max(l_orderkey), max(l_partkey), max(l_suppkey), count(*) from lineitem
where l_partkey < 25000000
and l_suppkey < 1250000
and l_orderkey < 100000000
and l_linenumber = 4
and l_quantity <= 5;
max(l_orderkey) max(l_partkey) max(l_suppkey) count(*)
5999938 199997 10000 85687