表tbjob id,userid,jontime
表tbuser id,name
求 根据时间desc 去重 userid
不知道意思表达的清楚不
select name from tbuser where id in(select userid from tbjob group by userid having count(userid)>1 order by jontime desc)
------解决方案--------------------
- SQL code
create table tbjob(id int, userid varchar(5), jontime datetime)insert into tbjobselect 1, '0001', '2012-1-1 00:12:02' union allselect 2, '0001', '2012-1-1 10:12:12' union allselect 3, '0002', '2012-1-1 11:12:12' union allselect 4, '0002', '2012-1-2 12:12:12' union allselect 5, '0003', '2012-3-4 01:12:12'with t as(select row_number() over(partition by userid order by jontime desc) rn, id,userid,jontime from tbjob)select id,userid,jontimefrom twhere rn=1order by jontime descid userid jontime----------- ------ -----------------------5 0003 2012-03-04 01:12:12.0004 0002 2012-01-02 12:12:12.0002 0001 2012-01-01 10:12:12.000(3 row(s) affected)