sql 去重（DISTINCT）详解

最新推荐文章于 2025-04-04 21:39:26 发布

一个java菜鸟的成长之路

最新推荐文章于 2025-04-04 21:39:26 发布

阅读量1w

点赞数 1

分类专栏：数据库分页文章标签： sql select

本文链接：https://blog.youkuaiyun.com/past__time/article/details/72956008

版权

数据库分页专栏收录该内容

4 篇文章

订阅专栏

//直接上sql
SELECT
    DISTINCT up.usersid,
    rs.NewName,
    el.LevelName,
    u.Account,
    ui.Name,
    ui.Icon
FROM
    UsersPower up
LEFT JOIN RoleSet rs ON rs.Num = up.RoleId
LEFT JOIN Department d ON d.id = up.DepartmentID
LEFT JOIN EmployeeLevel el ON el.id = up.LevelID
LEFT JOIN Users u ON u.id = up.usersid
LEFT JOIN UserInfo ui ON u.id = ui.UsersId
WHERE
    up.CompanyInfoId = 18
AND up.RoleId =11
AND rs.CompanyInfoId = 18
这样的话DISTINCT这个函数会根据你所有要查询的字段进行去重。