統計函數
更新時間 2025-02-14 10:22:13
最近更新時間: 2025-02-14 10:22:13
分享文章
本頁介紹天翼云TeleDB數據庫Oracle語法中的統計函數。
listagg
listagg (filedname,',') WITHIN GROUP (ORDER BY filedname)行轉列函數。
teledb=# create table person
teledb-# (
teledb(# deptno varchar2(10),
teledb(# ename varchar(20)
teledb(# );
CREATE TABLE
teledb=# insert into person values('20','aaa');
INSERT 0 1
teledb=#
teledb=# insert into person values('20','bbb');
INSERT 0 1
teledb=#
teledb=# insert into person values('20','ccc');
INSERT 0 1
teledb=#
teledb=# insert into person values('21','ddd');
INSERT 0 1
teledb=#
teledb=# insert into person values('21','eee');
INSERT 0 1
teledb=# select
teledb-# deptno,
teledb-# listagg (ename,',') WITHIN GROUP (ORDER BY ENAME)
teledb-# from
teledb-# person
teledb-# group by
teledb-# deptno ;
deptno | listagg
--------+-------------
20 | aaa,bbb,ccc
21 | ddd,eee
(2 rows)
