sql查找去重复并且字段不为空的数据

select distinct username,quantity  from Student where isnull(username,'')<>'' and p_id = {1}