select top 10 * from table1 a
where exists(select 1 from table1 where name=a.name and v_times>=a.v_times having count(*)<=2)
order by v_times desc
where exists(select 1 from table1 where name=a.name and v_times>=a.v_times having count(*)<=2)
order by v_times desc
from t a
where title in (select top 2 title from t where name=a.name order by v_times desc)
order by v_times desc
where title in (select top 2 title from table1 where name=a.name order by v_times desc)
order by v_times desc
from t a
where title in (select top 2 title from t where name=a.name order by v_times desc)
order by v_times desc好聪明的办法啊