(1)select gdRMJN_ZRZ from Project_SetGDRule_JN where ruleID='1802'显示原来的ZRZ(2)select PJN_ZRZ,count(PJN_ZRZ) as Frequency from matchHistoryLog where MHL_matchState=1
and ruleID='1802' group by PJN_ZRZ 显示matchHistoryLog表中不同ZRZ出现的次数
要实现在显示matchHistoryLog表中不同ZRZ出现的次数的同时,显示对应的原来的ZRZ,该怎么写?(3)select b.gdRMJN_ZRZ as PJN_OldKEY,a.PJN_ZRZ as PJN_NEWKEY,count(PJN_ZRZ) as Frequency from matchHistoryLog as a join Project_SetGDRule_JN as b on a.ruleID=b.ruleID and a.ruleID='1802'
and MHL_matchState=1 group by a.PJN_ZRZ,b.gdRMJN_ZRZ 计算的频度与(2)不同,求解释。
and ruleID='1802' group by PJN_ZRZ 显示matchHistoryLog表中不同ZRZ出现的次数
要实现在显示matchHistoryLog表中不同ZRZ出现的次数的同时,显示对应的原来的ZRZ,该怎么写?(3)select b.gdRMJN_ZRZ as PJN_OldKEY,a.PJN_ZRZ as PJN_NEWKEY,count(PJN_ZRZ) as Frequency from matchHistoryLog as a join Project_SetGDRule_JN as b on a.ruleID=b.ruleID and a.ruleID='1802'
and MHL_matchState=1 group by a.PJN_ZRZ,b.gdRMJN_ZRZ 计算的频度与(2)不同,求解释。
解决方案 »
- 数据库查询非常慢可能是什么原因,如何解决?
- sql server 多个表被注入,郁闷!
- 求这条SQL语句如何写?
- accesss含有4.078#-1200#-1000#0.6#1.5#0.07的文本字段,如何逐个取出其中的数据
- 求一sql语句
- 紧急请教一句多表关联的SQL语句.
- select A,sum(B) AS C from myTable group by Name,我怎样在C中选出最大的?
- 再问一个SQL,接着我的思路
- 如何实现两个SQL Server 7.0数据库信息的同步更新?
- sql根据行, 分行 分组 并分别统计个个类型的总数
- 收缩数据库异常,请大家一起解决
- 四个表结构不一样 查询计数
(
select PJN_ZRZ,count(PJN_ZRZ) as Frequency from matchHistoryLog where MHL_matchState=1
) a,
Project_SetGDRule_JN as b
on a.ruleID=b.ruleID
b.gdRMJN_ZRZ as PJN_OldKEY,a.PJN_ZRZ as PJN_NEWKEY,count(PJN_ZRZ) as Frequency from
(
select PJN_ZRZ,count(PJN_ZRZ) as Frequency from matchHistoryLog where MHL_matchState=1
) a join Project_SetGDRule_JN b
on a.ruleID=b.ruleID