如何在Sqlserver中将两行合并为一个？ [英] How to combine two rows into one in Sqlserver ?

问题描述

有谁能告诉我如何将两行合二为一。

Hi,
Can anyone tell me How to combine two rows into one.

EMPCode	    actHours	        actDate		rowno
107	    8.00		2013-01-21 	1
107	    8.30		2013-01-22 	1
107	    4.00		2013-01-23 	1
107	    4.00		2013-01-23 	2
107	    4.10		2013-01-24 	1
107	    4.20		2013-01-24 	2
107	    4.30		2013-01-25 	1
107	    4.30		2013-01-25 	2

I want the result as follows:

actHours	   actDate	
8.00		   2013-01-21 
8.30		   2013-01-22
8.00		   2013-01-23 
8.30		   2013-01-24
9.00		   2013-01-25 	

任何帮助将不胜感激。在此先感谢： - ）

Any help will be appreciated. Thanks in advance :-)

推荐答案

您好，



尝试以下解决方案

Hi,

Try below solution

select
 convert (int , ( sum( (CONVERT(INT, actHours) * 60 ) + ( ( actHours - (CONVERT(INT, actHours) ) )  * 100 ) )/60 ) ) +

( ( sum( (CONVERT(INT, actHours) * 60 ) + ( ( actHours - (CONVERT(INT, actHours) ) )  * 100 ) )/60 )-
 convert (int , ( sum( (CONVERT(INT, actHours) * 60 ) + ( ( actHours - (CONVERT(INT, actHours) ) )  * 100 ) )/60 ) ) ) * .60,
 MAX(actDate)
FROM TABLE_1 GROUP BY actDate

如果我有这个问题：



SELECT SUM（actHours）as actHours，actDate

FROM * YourTableName *

GROUP BY actDate

If I have got this correnctly :

SELECT SUM(actHours) as actHours, actDate
FROM *YourTableName*
GROUP BY actDate

这篇关于如何在Sqlserver中将两行合并为一个？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！