在一行中获取两行

本文介绍了在一行中获取两行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 我有一张桌子报告如下 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但无法得到我想要的东西。解决方案 Hi,I have a table Report as belowGroup_Display_NameEquipment_Display_NameParameter NameRequired PoundsActual PoundsSECOND GroupLIME AMOUNT_ADDED07245.495605SECOND GroupLIME CHARGE_AMOUNT72630SECOND GroupMETHANOLAMOUNT_ADDED05714.498047SECOND GroupMETHANOLCHARGE_AMOUNT00THIRD GroupLIME AMOUNT_ADDED03603.398926THIRD GroupLIME CHARGE_AMOUNT36250THIRD GroupXYLENE AMOUNT_ADDED010177.30566THIRD GroupXYLENE CHARGE_AMOUNT100700Every 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.495605Second Group Methanol 0 5714.498047Column Parameter Name, I do not want to display.What I have tried:I tried to use CASE but could not get what I want. 解决方案 这篇关于在一行中获取两行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！