sql统计用户在地铁上的花费时间
发布时间：2024-12-14 07:45:16selectID,SUM(f1)as"总耗时(S)"from(selectID,datediff(SECOND,(selectMAX(time)fromz_1t2wheret2.money=0andt1.time>=t2.time),time)asf1fromz_1t1wheremoney>0)agroupbyid
selectID,SUM(f1)as"总耗时(S)"from(selectID,datediff(SECOND,(selectMAX(time)fromz_1t2wheret2.money=0andt1.time>=t2.time),time)asf1fromz_1t1wheremoney>0)agroupbyid
