From a19e41d3c607aca7829c9aae8cd4aa07715a3a26 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 10 二月 2023 15:40:23 +0800
Subject: [PATCH] 1

---
 data/ts.sql |   17 +++++++++++++----
 1 files changed, 13 insertions(+), 4 deletions(-)

diff --git a/data/ts.sql b/data/ts.sql
index 3dfba03..ebf8427 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -129,13 +129,22 @@
 select * from lf.sys_serve_log;
 select * from lf.sys_meta;
 select * from lf.sys_operate order by id desc limit 20;
+select * from lf.sys_report;
 
+select fn_rec_query(depid, 'dep') "m1" , count(sizes) "sizes"
+from lf.sys_meta
+group by depid
+order by depid;
 
+select name "m1", count(*) "count"
+from lf.sys_serve_log
+group by name
+order by name;
 
-
-
-
-
+select modular1 "m1", modular2 "m2", count(*) "count"
+from lf.sys_operate
+group by modular1,modular2
+order by modular1 desc,modular2;
 
 
 

--
Gitblit v1.9.3