1.删除重複，保留一條groupID最小那一天
delete * from [Metadata_ForGZBB].[dbo].[Group] where groupID<>(select MIN(groupID) from [Metadata_ForGZBB].[dbo].[Group] a where a.groupName='S送水泵房總站') and groupName='S送水泵房總站'
1.删除重複，保留一條groupID最小那一天
delete * from [Metadata_ForGZBB].[dbo].[Group] where groupID<>(select MIN(groupID) from [Metadata_ForGZBB].[dbo].[Group] a where a.groupName='S送水泵房總站') and groupName='S送水泵房總站'
![sql的行轉列(PIVOT)與列轉行(UNPIVOT) [圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)