SELECT * FROM user WHERE Uid IN ( select min(Uid) from user group by Sid ) 转载于:https://www.cnblogs.com/gjack/p/10326651.html