我有下面的sql表,我想删除重复的条目时 object_id
比赛 team_name
. 基本上我想要的是 object_id
```
session_id object_id team_name user_name user_desc
session1 user1 team1 user1 user1_description
session1 user2 team1 user2 user2_description
session1 team1 team1 user1 user1_description
session1 team1 team1 user2 user2_description
我想把上表转换成下表
session_id object_id team_name user_name user_desc
session1 user1 team1 user1 user1_description
session1 user2 team1 user2 user2_description
session1 team1 team1 null null
我要怎么做?
1条答案
按热度按时间vc6uscn91#
如果我理解正确,您可以使用聚合: