select distinct username,quantity from Student where isnull(username,'')<>'' and p_id = {1} 转载于:https://www.cnblogs.com/superMay/p/6197975.html