注册

结果集数据展示不一致

奋斗的小淼 2024/10/18 402 7

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8 DB Version: 0x7000c
【操作系统】:WINDOW
【CPU】:X86
【问题描述】*:

drop table if exists t1 ;
CREATE TABLE "T1"
(
"A" VARCHAR(8) NOT NULL,
"B" VARCHAR(8) NOT NULL,
NOT CLUSTER PRIMARY KEY("A", "B")) STORAGE(ON "MAIN", CLUSTERBTR) ;
insert into T1 values('1','1');
insert into T1 values('2','2');
insert into T1 values('3','3');
commit;

运行下面两个展示不一样

select top 0,101 * from ( select distinct a from "TEST"."T1" order by a desc);

select distinct a from "TEST"."T1" order by a desc;

image.png

image.png

回答 0
暂无回答
扫一扫
联系客服