SELECT DISTINCT o.* FROM operatelog o INNER JOIN sys_user u ON o.user_id = u.id LEFT JOIN sys_user_department d ON d.user_id = u.id ${ew.customSqlSegment}加个条件modifytype=131
时间: 2024-01-17 07:03:24 浏览: 34
如果您想加上条件 `modifytype=131`,可以在这个 SQL 查询语句的最后加上 `AND modifytype=131`。修改后的 SQL 查询语句如下:
```
SELECT DISTINCT o.*
FROM operatelog o
INNER JOIN sys_user u ON o.user_id = u.id
LEFT JOIN sys_user_department d ON d.user_id = u.id
${ew.customSqlSegment}
AND modifytype=131
```
注意,这里的 `${ew.customSqlSegment}` 是一个占位符,具体的查询条件需要根据您的实际情况进行替换。
相关问题
SELECT DISTINCT m.* FROM sys_menu m LEFT JOIN sys_role_menu rm ON m.menu_id = rm.menu_id LEFT JOIN sys_role r ON r.role_id = rm.role_id WHERE r.role_id IN (SELECT role_id FROM sys_user_role WHERE user_id=?) AND m.TYPE = 0 ORDER BY m.order_num
这是一条 SQL 查询语句,用于查询指定用户所拥有的菜单权限。具体来说,该语句会查询 sys_menu 表中所有类型为菜单的记录,并且这些菜单所对应的角色中包含该用户所拥有的角色的记录。查询结果按照菜单的 order_num 字段进行排序。其中,`?` 表示一个占位符,需要在执行查询时传入实际的用户 ID 值。
SELECT DISTINCT rror.recyclebin_id AS recyclebinId, rdt.name AS recyclebinName, sur.phonenumber AS phone, sur.nick_name AS nickName FROM re_order ror INNER JOIN re_recyclebin_order rror ON rror.id = ror.recyclebin_order_id INNER JOIN re_digit_recyclebin rdt ON rdt.id = rror.recyclebin_id left join sys_user sur ON rdt.admin_id = sur.user_id WHERE ror.order_status = '50' AND order_user = #{userId} Order By ror.complete_time DESC 影响了顺序,帮我改一下
可以将 Order By 子句放在整个 SQL 语句的最后,如下所示:
SELECT DISTINCT
rror.recyclebin_id AS recyclebinId,
rdt.name AS recyclebinName,
sur.phonenumber AS phone,
sur.nick_name AS nickName
FROM
re_order ror
INNER JOIN re_recyclebin_order rror ON rror.id = ror.recyclebin_order_id
INNER JOIN re_digit_recyclebin rdt ON rdt.id = rror.recyclebin_id
LEFT JOIN sys_user sur ON rdt.admin_id = sur.user_id
WHERE
ror.order_status = '50'
AND order_user = #{userId}
ORDER BY
ror.complete_time DESC
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)