多表联查（左联）计算多个子查询的Count数作为属性输出

最新推荐文章于 2020-04-15 10:10:43 发布
最新推荐文章于 2020-04-15 10:10:43 发布
阅读量893 收藏
点赞数
原文链接：https://my.oschina.net/8824/blog/3098947
版权

 

服务实现描述
1 、 FDC_View_Status_Report_By_Res
1 ） ProcStep=1 ：按 Fab 查。联合查询 FDCLOCATION 、 FDCRES 、 FDCDCP 表，
查询条件为
RES_CONNECTED ：
1. FDCLOCATION.FACTORY = FDCRES.FACTORY
2. 且 FDCLOCATION.LOCATION_ID = FDCRES.LOCATION_ID
3. 且 FDCLOCATION.FAB = InTag.CONDITION_1
4. 得到查找结果的行数
RES_ACTIVATED ：
1. FDCLOCATION.FACTORY = FDCRES.FACTORY
2. 且 FDCRES.FACTORY = FDCDCP.FACTORY
3. 且 FDCLOCATION.LOCATION_ID = FDCRES.LOCATION_ID
4. 且 FDCRES.RES_ID = FDCDCP.RES_ID
5. 且 FDCDCP.DCP_STATUS = “ACTIVED”
6. 且 FDCLOCATION.FAB = InTag.CONDITION_1
7. 得到查找结果的行数
MODULE_CONNECTED ：
1. 且 FDCLOCATION.FACTORY = FDCRES.FACTORY
2. 且 FDCLOCATION.LOCATION_ID = FDCRES.LOCATION_ID
3. 且 FDCLOCATION.FAB = InTag.CONDITION_1
4. 得到 GROUP BY PARENT_RES_ID 的结果行数
返回参数： SITE 、 FAB 、 LINE 、 RES_CONNECTED 、 RES_ACTIVATED 、
MODULE_CONNECTED
2 ） ProcStep=2 ：按 Line 查
3 ） ProcStep=3 ：按 Area 查
4 ） ProcStep=4 ：按 Res Model 查
5 ） ProcStep=5 ：按 Res Module 查：查询 FDCTRACETRXDATA 表，查询条件为
6 ） 返回查询结果列表
2 、 FDC_View_Lot_History_Detail
1 ） 查询 FDCDCP 表，查询条件为
RAWID = InTag.RAWID
2 ） 返回查询结果
======ProStep=1（Fab）： 
            string sFactory = "SYSTEM";
            string sFab = "**";
            var query1 = ctx.Fdclocation
                .Where(t => t.Factory == sFactory && t.Fab == sFab)
                .Select(t => new { t.Site, t.Fab, t.Line })
                .Distinct();
            var query2 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.Fab == sFab && t.r.ResLevel == 0)
                .GroupBy(t => t.l.Line)
                .Select(g => new { Line = g.Key, RES_CONNECTED = g.Count() });
            var query3 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Join(ctx.Fdcdcp, l2 => new { l2.l.Factory, l2.r.ResId }, r2=> new { r2.Factory, r2.ResId }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory && t.l2.l.Fab == sFab && t.l2.r.ResLevel == 0 && t.r2.DcpState == "ACTIVE")
                .GroupBy(t => t.l2.l.Line)
                .Select(g => new { Line = g.Key, RES_ACTIVATED = g.Count() });
            var query4 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.Fab == sFab && t.r.ResLevel > 0)
                .GroupBy(t => t.l.Line)
                .Select(g => new { Line = g.Key, MODULE_CONNECTED = g.Count() });
            var query = query1
                .GroupJoin(query2, l => l.Line, r => r.Line, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Line = "", RES_CONNECTED = 0 }), (a, b) => new { a.l.Site, a.l.Fab, a.l.Line, b.RES_CONNECTED })
                .GroupJoin(query3, l => l.Line, r => r.Line, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Line = "", RES_ACTIVATED = 0 }), (a, b) => new { a.l.Site, a.l.Fab, a.l.Line, a.l.RES_CONNECTED, b.RES_ACTIVATED })
                .GroupJoin(query4, l => l.Line, r => r.Line, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Line = "", MODULE_CONNECTED = 0 }), (a, b) => new { a.l.Site, a.l.Fab, a.l.Line, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, b.MODULE_CONNECTED })
                .Select(t => new { t.Site, t.Fab, t.Line, t.RES_CONNECTED, t.RES_ACTIVATED, t.MODULE_CONNECTED })
                .ToList();

======ProStep=2（Line）：

            var query1 = ctx.Fdclocation
                .Where(t => t.Factory == sFactory && t.Line == sLine)
                .Select(t => new { t.Area })
                .Distinct();
            var query2 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.Line == sLine && t.r.ResLevel == 0)
                .GroupBy(t => t.l.Area)
                .Select(g => new { Area = g.Key, RES_CONNECTED = g.Count() });
            var query3 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Join(ctx.Fdcdcp, l2 => new { l2.l.Factory, l2.r.ResId }, r2 => new { r2.Factory, r2.ResId }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory && t.l2.l.Line == sLine && t.l2.r.ResLevel == 0 && t.r2.DcpState == "ACTIVE")
                .GroupBy(t => t.l2.l.Area)
                .Select(g => new { Area = g.Key, RES_ACTIVATED = g.Count() });
            var query4 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.Line == sLine && t.r.ResLevel > 0)
                .GroupBy(t => t.l.Area)
                .Select(g => new { Area = g.Key, MODULE_CONNECTED = g.Count() });
            var query5 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Join(ctx.Fdcdcptracepara, l2 => new { l2.l.Factory, l2.r.ResId }, r2 => new { r2.Factory, r2.ResId }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory && t.l2.l.Line == sLine)
                .GroupBy(t => t.l2.l.Area)
                .Select(g => new { Area = g.Key, TRACE_PARA_COLLECTED = g.Count() });
            var query6 = ctx.Fdclocation
                .Join(ctx.Fdcres, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Join(ctx.Fdcdcptracepara, l2 => new { l2.l.Factory, l2.r.ResId }, r2 => new { r2.Factory, r2.ResId }, (l2, r2) => new { l2, r2 })
                .Join(ctx.Fdctracespec, l3 => new { l3.l2.l.Factory, l3.r2.ParaDisplayName }, r3 => new { r3.Factory, r3.ParaDisplayName }, (l3, r3) => new { l3, r3 })
                .Where(t => t.l3.l2.l.Factory == sFactory && t.l3.l2.l.Line == sLine)
                .GroupBy(t => t.l3.l2.l.Area)
                .Select(g => new { Area = g.Key, TRACE_PARA_MODELED = g.Count() });
            var query = query1
                .GroupJoin(query2, l => l.Area, r => r.Area, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Area = "", RES_CONNECTED = 0 }), (a, b) => new { a.l.Area, b.RES_CONNECTED })
                .GroupJoin(query3, l => l.Area, r => r.Area, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Area = "", RES_ACTIVATED = 0 }), (a, b) => new { a.l.Area, a.l.RES_CONNECTED, b.RES_ACTIVATED })
                .GroupJoin(query4, l => l.Area, r => r.Area, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Area = "", MODULE_CONNECTED = 0 }), (a, b) => new { a.l.Area, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, b.MODULE_CONNECTED })
                .GroupJoin(query5, l => l.Area, r => r.Area, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Area = "", TRACE_PARA_COLLECTED = 0 }), (a, b) => new { a.l.Area, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, a.l.MODULE_CONNECTED, b.TRACE_PARA_COLLECTED })
                .GroupJoin(query6, l => l.Area, r => r.Area, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { Area = "", TRACE_PARA_MODELED = 0 }), (a, b) => new { a.l.Area, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, a.l.MODULE_CONNECTED, a.l.TRACE_PARA_COLLECTED, b.TRACE_PARA_MODELED })
                .Select(t => new { t.Area, t.RES_CONNECTED, t.RES_ACTIVATED, t.MODULE_CONNECTED, t.TRACE_PARA_COLLECTED, EVENT_PARA_COLLECTED = 0, RECIPE_MODELED = 0, TRACE_SUM_PARAS = 0, EVENT_SUM_PARAS = 0, t.TRACE_PARA_MODELED, EVENT_COUNT = 0 })
                .ToList();

======ProStep=3（Area）：

            var query1 = ctx.Fdclocation
                .Join(ctx.Fdcresmodel, l => new { l.Factory, l.LocationId }, r => new { r.Factory, r.LocationId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.Area == sArea)
                .Select(t => new { t.r.ModelId })
                .Distinct();
            var query2 = ctx.Fdcres
                .Where(t => t.Factory == sFactory && t.ResLevel == 0)
                .GroupBy(t => t.ResModelId)
                .Select(g => new { ModelId = g.Key, RES_CONNECTED = g.Count() });
            var query3 = ctx.Fdcres
                .Join(ctx.Fdcdcp, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory && t.l.ResLevel == 0 && t.r.DcpState == "ACTIVE")
                .GroupBy(t => t.l.ResModelId)
                .Select(g => new { ModelId = g.Key, RES_ACTIVATED = g.Count() });
            var query4 = ctx.Fdcres
                .Where(t => t.Factory == sFactory && t.ResLevel > 0)
                .GroupBy(t => t.ResModelId)
                .Select(g => new { ModelId = g.Key, MODULE_CONNECTED = g.Count() });
            var query5 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory)
                .GroupBy(t => t.l.ResModelId)
                .Select(g => new { ModelId = g.Key, TRACE_PARA_COLLECTED = g.Count() });
            var query6 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Join(ctx.Fdctracespec, l2 => new { l2.l.Factory, l2.r.ParaDisplayName }, r2 => new { r2.Factory, r2.ParaDisplayName }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory)
                .GroupBy(t => t.l2.l.ResModelId)
                .Select(g => new { ModelId = g.Key, TRACE_PARA_MODELED = g.Count() });
            var query = query1
                .GroupJoin(query2, l => l.ModelId, r => r.ModelId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ModelId = "", RES_CONNECTED = 0 }), (a, b) => new { a.l.ModelId, b.RES_CONNECTED })
                .GroupJoin(query3, l => l.ModelId, r => r.ModelId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ModelId = "", RES_ACTIVATED = 0 }), (a, b) => new { a.l.ModelId, a.l.RES_CONNECTED, b.RES_ACTIVATED })
                .GroupJoin(query4, l => l.ModelId, r => r.ModelId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ModelId = "", MODULE_CONNECTED = 0 }), (a, b) => new { a.l.ModelId, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, b.MODULE_CONNECTED })
                .GroupJoin(query5, l => l.ModelId, r => r.ModelId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ModelId = "", TRACE_PARA_COLLECTED = 0 }), (a, b) => new { a.l.ModelId, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, a.l.MODULE_CONNECTED, b.TRACE_PARA_COLLECTED })
                .GroupJoin(query6, l => l.ModelId, r => r.ModelId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ModelId = "", TRACE_PARA_MODELED = 0 }), (a, b) => new { a.l.ModelId, a.l.RES_CONNECTED, a.l.RES_ACTIVATED, a.l.MODULE_CONNECTED, a.l.TRACE_PARA_COLLECTED, b.TRACE_PARA_MODELED })
                .Select(t => new { t.ModelId, t.RES_CONNECTED, t.RES_ACTIVATED, t.MODULE_CONNECTED, t.TRACE_PARA_COLLECTED, EVENT_PARA_COLLECTED = 0, RECIPE_MODELED = 0, TRACE_SUM_PARAS = 0, EVENT_SUM_PARAS = 0, t.TRACE_PARA_MODELED, EVENT_COUNT = 0 })
                .ToList();

======ProStep=4（Model）：

            var query1 = ctx.Fdcres
                .Where(t => t.Factory == sFactory && t.ResModelId == sModelId && t.ResLevel == 0)
                .Select(t => new { t.ResId })
                .Distinct();
            var query2 = ctx.Fdcres
                .Where(t => t.Factory == sFactory && t.ResLevel > 0)
                .GroupBy(t => t.BaseResId)
                .Select(g => new { ResId = g.Key, MODULE_CONNECTED = g.Count() });
            var query3 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory)
                .GroupBy(t => t.l.ResId)
                .Select(g => new { ResId = g.Key, TRACE_PARA_COLLECTED = g.Count() });
            var query4 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Join(ctx.Fdctracespec, l2 => new { l2.l.Factory, l2.r.ParaDisplayName }, r2 => new { r2.Factory, r2.ParaDisplayName }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory)
                .GroupBy(t => t.l2.l.ResId)
                .Select(g => new { ResId = g.Key, TRACE_PARA_MODELED = g.Count() });
            var query = query1
                .GroupJoin(query2, l => l.ResId, r => r.ResId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ResId = "", MODULE_CONNECTED = 0 }), (a, b) => new { a.l.ResId, b.MODULE_CONNECTED })
                .GroupJoin(query3, l => l.ResId, r => r.ResId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ResId = "", TRACE_PARA_COLLECTED = 0 }), (a, b) => new { a.l.ResId, a.l.MODULE_CONNECTED, b.TRACE_PARA_COLLECTED })
                .GroupJoin(query4, l => l.ResId, r => r.ResId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ResId = "", TRACE_PARA_MODELED = 0 }), (a, b) => new { a.l.ResId, a.l.MODULE_CONNECTED, a.l.TRACE_PARA_COLLECTED, b.TRACE_PARA_MODELED })
                .Select(t => new { t.ResId, t.MODULE_CONNECTED, t.TRACE_PARA_COLLECTED, EVENT_PARA_COLLECTED = 0, RECIPE_MODELED = 0, TRACE_SUM_PARAS = 0, EVENT_SUM_PARAS = 0, t.TRACE_PARA_MODELED, EVENT_COUNT = 0 })
                .ToList();

======ProStep=4（Res）：

            var query1 = ctx.Fdcres
                .Where(t => t.Factory == sFactory && t.BaseResId == sResId)
                .Select(t => new { t.ResId })
                .Distinct();
            var query2 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Where(t => t.l.Factory == sFactory)
                .GroupBy(t => t.l.ResId)
                .Select(g => new { ResId = g.Key, TRACE_PARA_COLLECTED = g.Count() });
            var query3 = ctx.Fdcres
                .Join(ctx.Fdcdcptracepara, l => new { l.Factory, l.ResId }, r => new { r.Factory, r.ResId }, (l, r) => new { l, r })
                .Join(ctx.Fdctracespec, l2 => new { l2.l.Factory, l2.r.ParaDisplayName }, r2 => new { r2.Factory, r2.ParaDisplayName }, (l2, r2) => new { l2, r2 })
                .Where(t => t.l2.l.Factory == sFactory)
                .GroupBy(t => t.l2.l.ResId)
                .Select(g => new { ResId = g.Key, TRACE_PARA_MODELED = g.Count() });
            var query = query1
                .GroupJoin(query2, l => l.ResId, r => r.ResId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ResId = "", TRACE_PARA_COLLECTED = 0 }), (a, b) => new { a.l.ResId, b.TRACE_PARA_COLLECTED })
                .GroupJoin(query3, l => l.ResId, r => r.ResId, (l, r) => new { l, r })
                .SelectMany(lr => lr.r.DefaultIfEmpty(new { ResId = "", TRACE_PARA_MODELED = 0 }), (a, b) => new { a.l.ResId, a.l.TRACE_PARA_COLLECTED, b.TRACE_PARA_MODELED })
                .Select(t => new { t.ResId, t.TRACE_PARA_COLLECTED, EVENT_PARA_COLLECTED = 0, RECIPE_MODELED = 0, TRACE_SUM_PARAS = 0, EVENT_SUM_PARAS = 0, t.TRACE_PARA_MODELED, EVENT_COUNT = 0 })
                .ToList();

 

转载于:https://my.oschina.net/8824/blog/3098947

ciixcxy521659
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql多表左联分组查询
yamiyoyo的博客
08-06 1767
在做项目的时候需要实现一个多表左联加分组查询的逻辑。 下图是前端要显示的数据，数据来源于三张表： ETC表：cap_etc 车辆表：cap_vehicle ETC消费表：cap_etc_record 下图是后台的三张数据表： cap_etc: cap_vehicle: cap_etc_record: 涉及的问题： 如何将三张表的数据联系起来 消费表里记录的是 ...
数据库表连接后获取记录条数之COUNT函数
chhuma专栏
03-06 3453
问题背景： 今天Java开发工程师咨询，如下SQL语句COUNT函数值怎么会比表T_1行数、表T_2行数都大？ 并说是不是ORACLE数据库的BUG？ SQL： select count(*) from t_1, t_2 where t_1.id=t_2.id and t_1.id=1; 其中T_1、T_2表结构如下： create table t_1 (   id numbe
DevExpress-ChartControl获取barWidth In Pixel
cxu123321的博客
12-13 525
坑:如果是SideBySideStackedBarSeriesView的话, 看看有 多少个 Group 需要 注意一下 private void chartControl1_CustomPaint(object sender, DevExpress.XtraCharts.CustomPaintEventArgs e) { var chart = ( ChartC...
jquery实现多级联查
BigDevil_的博客
11-24 895
思路 前端： （都是用的bootstrap和jquery） 第一级： 在html写出select标签，然后访问后台的获取数据 然后js中添加<option>标签拼接数据 -----获取第一级的另一个方法：在后端的controller层中添加Model对象，把获取到的pojo集合放进model属性中，在jsp里 用c标签 循环添加 第二级： 在第一级中添加οnchange=“ get...
MySQL左联多表查询where条件写法示例
09-10
然后，这两个子查询作为新的临时表参与左连接。这样，即使在b表中找不到与a表匹配的记录，原始的左连接意图也能得到保留，因为我们已经在子查询阶段完成了条件过滤。 总结一下，当进行左联多表查询时，where条件的...
thinkPHP5框架实现多数据库连接，跨数据连接查询操作示例
01-20
本文实例讲述了thinkPHP5框架实现多数据库连接，跨数据连接查询操作。分享给大家供大家参考，具体如下： 1. 多数据库连接 方法1：在需要连接其他数据库的地方，使用Db::connect()方法动态连接数据库，方法参数为...
axure rp9.0 左联菜单功能框架
07-05
左侧菜单使用中继器进行菜单的动态加载，菜单分两级，可建立多个菜单。在多个菜单进行功能切换时，自动实现菜单的打开、关闭的交互。使用时，只要将现有的功能名称，菜单名称维护到中继器的数据集，即可实现。新建...
Oracle左连接返回多条记录中一条记录的查询语句
03-01
Oracle左连接返回多条记录中一条记录的查询语句,更具指定条件分组排序，返回各组中第一条记录
sql语句 两表关联查询计算数量
dejz8829的专栏
01-17 3559
select sum(a1.`num`) from `order_orderlistrow` as a1 INNER JOIN `order_orderlist` as a2 on a1.`order_orderlist_id` = a2.`id` where a1.`goods_good_id` ='54' and a2.`state` <> '0' 转载于:ht...
数据库自联表查询
ITX2000的专栏
07-17 2122
select  HTTYPE, t1.Factory, t1.H_user as 财务1,t2.H_user as 财务2,t3.H_user as 财务3 , t4.H_user as 财务4  from notices as t1,notices as t2,notices as t3 , notices as t4 ,heton where  t1.H_Type='0' and t1.t
设置DevExpress XtraChart控件Series的特定颜色
黑桃Q的专栏
04-08 5559
private void InitChartData(DataTable dtsource)         {             chartOperateBar.Series.Clear();                        //柱形图             chartOperateBar.DataSource =dtsource;
JPA多条件组合查询,多表关联查询,数据条数<count>（CriteriaQuery）
热门推荐
乐闻世界
05-31 1万+
JPA多条件组合查询（CriteriaQuery） /**查询Demo结果集 * @return */ public List&lt;Demo&gt; findDemoList(ParamVO param,Pageable pageable,List&lt;Integer&gt; userIds){ List&lt;Demo&gt; resu...
select count from multiple tables（多表计数查询）
全名工作狂的小城堡
08-11 1万+
今天在实验楼上面学习sql语句，觉得好有成就感。卡在作业题目上面卡了好久。 题目是这样：使用连接查询的方式，查询出**各员工所在部门的人数与工程数**，工程数命名为count_project。（连接3个表，并使用COUNT内置函数）做了很多尝试，列出表的内容等等。 具体尝试内容可以查看这里：https://www.shiyanlou.com/courses/reports/549775 最终在
使用spring data jpa多表关联查询遇到count计数问题
简丶简的博客
04-15 2353
`` @Query(value = "SELECT * FROM USERS u left join class cl on u.class_id = cl.id WHERE LASTNAME = ?1",nativeQuery = true) Page<User> findByLastname(String lastname, Pageable pageable); ...
如果mysql 左联多张表，如何写
最新发布
05-27
其中，`table1`是需要查询的主表，`table2`, `table3`, `table4`等是需要左联的表，`column_name`是两个表共有的列名，用于关联两个表的数据。 在实际应用中，可以根据具体的业务需求来进行左联多张表的操作，需要...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值