SQL查询如何将行转换为列I ...? [英] How do SQL query to convert rows to columns I...?
问题描述
我有一个数据表,如下所示,
/ sno / /医生姓名/ / Total Revenu / / Flag /
------------------------------------------------- ------
1 DR.SALIM 163496.54药房销售
2 Dr.ARUN 16124.14药房销售
3 DR.SALIM 47150 LAB
4 SHAMNAD博士2060放电
5 DR.SALIM 38830放电
使用SQL查询转换成如下表格,
/ sno / /医生/ /药房销售额/ /实验室数量/ / IP排放量/
-------------------------------------------- ------------------------
1 DR.SALIM 163496.54 47150.00 38830.00
2博士ARUN 16124.14 0.00 0.00
3 Dr.SHAMNAD 0.00 0.00 2060.00
谢谢...
我尝试了什么:
试过SQL查询临时表
I have one table of data as shown below,
/Sno/ /Doctor Name/ /Total Revenu/ /Flag/
-------------------------------------------------------
1 DR.SALIM 163496.54 Pharmacy Sales
2 Dr.ARUN 16124.14 Pharmacy Sales
3 DR.SALIM 47150 LAB
4 Dr. SHAMNAD 2060 Discharge
5 DR.SALIM 38830 Discharge
converted into a table like below using SQL query,
/Sno/ /Doctors/ /Pharmacy Sales amount/ /Lab amount/ /IP Discharge amount/
--------------------------------------------------------------------
1 DR.SALIM 163496.54 47150.00 38830.00
2 Dr.ARUN 16124.14 0.00 0.00
3 Dr.SHAMNAD 0.00 0.00 2060.00
Thank you...
What I have tried:
tried SQL query with a temp table
推荐答案
请参阅此处:使用PIVOT和UNPIVOT | Microsoft Docs [ ^ ]
这篇关于SQL查询如何将行转换为列I ...?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!