在一行中获取两行 [英] Get two rows in a single row

问题描述

我有一张桌子报告如下

 Group_Display_Name Equipment_Display_Name参数名称必需磅实际磅
 SECOND Group LIME AMOUNT_ADDED 0 7245.495605 
 SECOND Group LIME CHARGE_AMOUNT 7263 0 
 SECOND Group METHANOL AMOUNT_ADDED 0 5714.498047 
 SECOND Group METHANOL CHARGE_AMOUNT 0 0 
 THIRD Group LIME AMOUNT_ADDED 0 3603.398926 
 THIRD Group LIME CHARGE_AMOUNT 3625 0 
 THIRD Group XYLENE AMOUNT_ADDED 0 10177.30566 
 THIRD Group XYLENE CHARGE_AMOUNT 10070 0 

每个团体都有参数为费用金额和已添加金额的设备。

我想将这两行显示为一行，如

第二组LIME 7236 7245.495605 
第二组甲醇0 5714.498047 

列参数名称，我不想显示。



我尝试了什么：


我试图使用CASE但无法得到我想要的东西。

解决方案

试试这个：

  SELECT  Group_Display_Name，Equipment_Display_Name，SUM（[Required Pounds]） AS  RP，SUM（[实际磅]） AS  AP 
  FROM  YOUR_TABLE 
  GROUP   BY  Group_Display_Name，Equipment_Display_Name 

祝你好运！

请尝试：

  SELECT  Group_display_name，Equipment_Display_name，
 SUM（ CASE  PARAMETER_NAME  WHEN  < span class =code-string>'  CHARGE_AMOUNT' 那么 required_pounds  ELSE   0   END ） AS  c1，
 SUM（ CASE  PARAMETER_NAME  WHEN  '  CHARGE_AMOUNT' 那么  0   ELSE  actual_pounds  END ） AS  c2 
  FROM 数据
  GROUP   BY  Group_display_name，Equipment_Display_name 
  ORDER   by  Group_display_name，Equipment_Display_name 

Hi,
I have a table Report as below

Group_Display_Name	Equipment_Display_Name	Parameter Name	Required Pounds	Actual Pounds
SECOND Group	LIME	        AMOUNT_ADDED	0	7245.495605
SECOND Group	LIME	        CHARGE_AMOUNT	7263	0
SECOND Group	METHANOL	AMOUNT_ADDED	0	5714.498047
SECOND Group	METHANOL	CHARGE_AMOUNT	0	0
THIRD Group	LIME	        AMOUNT_ADDED	0	3603.398926
THIRD Group	LIME	        CHARGE_AMOUNT	3625	0
THIRD Group	XYLENE	        AMOUNT_ADDED	0	10177.30566
THIRD Group	XYLENE	        CHARGE_AMOUNT	10070	0

Every group has an equipment with Parameter as Charge Amount and Amount Added.
I want to show these two lines as one line like,

Second Group    LIME    7236    7245.495605
Second Group   Methanol    0   5714.498047

Column Parameter Name, I do not want to display.

What I have tried:

I tried to use CASE but could not get what I want.

解决方案

Try this:

SELECT Group_Display_Name, Equipment_Display_Name, SUM([Required Pounds]) AS RP, SUM([Actual Pounds]) AS AP
FROM YOUR_TABLE
GROUP BY Group_Display_Name, Equipment_Display_Name

Good luck!

Please try:

SELECT Group_display_name,Equipment_Display_name,
    SUM(CASE PARAMETER_NAME WHEN 'CHARGE_AMOUNT' THEN required_pounds ELSE 0 END) AS c1,
    SUM(CASE PARAMETER_NAME WHEN 'CHARGE_AMOUNT' THEN 0 ELSE actual_pounds END) AS c2
    FROM data
GROUP BY Group_display_name,Equipment_Display_name
ORDER  by Group_display_name,Equipment_Display_name

这篇关于在一行中获取两行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！