select * from v_userinfo v where uiid in (
select top 1 uiid from v_userinfo m where (m.uirole=v.uirole) order by uirole
) order by uirole
速度慢,如何提升?
"in"========>"="
select * from v_userinfo v where uiid in (
select top 1 uiid from v_userinfo m where (m.uirole=v.uirole) order by uirole
) order by uirole
速度慢,如何提升?
"in"========>"="