sql 去重 （DISTINCT）详解

//直接上sqlSELECT    DISTINCT up.usersid,    rs.NewName,    el.LevelName,    u.Account,    ui.Name,    ui.IconFROM    UsersPower upLEFT JOIN RoleSet rs ON rs.Num = up.RoleIdLEFT JOIN Department d ON d.id = up.DepartmentIDLEFT JOIN EmployeeLevel el ON el.id = up.LevelIDLEFT JOIN Users u ON u.id = up.usersidLEFT JOIN UserInfo ui ON u.id = ui.UsersIdWHERE    up.CompanyInfoId = 18AND up.RoleId =11AND rs.CompanyInfoId = 18这样的话DISTINCT这个函数会根据你所有要查询的字段进行去重。