22,209
社区成员
发帖
与我相关
我的任务
分享
select convert(carhcar(10),P_Time,120 ) as P_Time,min(P_Kaisu)
from tb
group by convert(carhcar(10),P_Time,120 )
--下面这个也可以的,就是一个判断、子查询
select *
from tb t
where not exists (select 1 from tb where datediff(dd,t.p_time,p_time)=0 and p_kaisu < t.p_kaisu)
select convert(varchar(10),P_Time,120) P_Time,min(P_Kaisu) P_Kaisu
from Game
group by convert(varchar,P_Time,120) P_Time
select convert(carhcar(10),P_Time,120 ) as P_Time,min(P_Kaisu)
from tb
group by convert(carhcar(10),P_Time,120 )
select *
from tb t
where not exists (select 1 from tb where datediff(dd,t.p_time,p_time)=0 and p_kaisu < t.p_kaisu)