| | |
| | | (select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "数量(MB)" |
| | | from lf.sys_dir a where id > 1 and pid = 0; |
| | | |
| | | -- 按文件类型统计 |
| | | select name "m1", (select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "sizes", |
| | | (select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "count" |
| | | from lf.sys_dir a where pid = 0 order by a.code; |
| | | |
| | | -- 按文件类型统计 * |
| | | select type,count(*),sum(sizes) from lf.sys_meta group by type; |
| | | select type "m1", cast(sum(sizes) as decimal(18, 3)) "sizes", count(*) "count" from lf.sys_meta group by type order by type; |
| | | |
| | | -- type类型:1-Shp文件,2-专题图,3-元数据,4-业务数据,5-管道分析,6-统计报告 |
| | | select * from lf.sys_download; |
| | |
| | | from lf.sys_dir d |
| | | where pid = 0 |
| | | order by d.code; |
| | | |
| | | --------------------------------------------------------- 02.递归查询 |
| | | with recursive rs as( |
| | | select * from lf.sys_menu where cn_name='管道基础大数据平台' |