56,677
社区成员
发帖
与我相关
我的任务
分享
select a.* from tb a where tr_id in ( select min(tr_id) from tb group by loginName, date_format(data_input_time, '%Y%m%d'))
select a.* from tb a where tr_id in ( select min(tr_id) from tb group by loginName, data_input_time)
select * from Table AS A where tri_Id =(select top 1 tri_Id From Table AS B WHERE
B.login_name=A.login_name ORDER BY data_input_time)