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 影响了顺序,帮我改一下
时间: 2024-02-15 08:28:49 浏览: 33
可以将 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
相关问题
select distinct S.customer_name from depositor as S where not exists ( (select branch_name from branch where branch_city = 'Brooklyn') except (select R.branch_name from depositor as T, account as R where T.account_number = R.account_number and S.customer_name = T.customer_name ))
这是一个SQL查询语句,其目的是查询在布鲁克林市没有开户的所有客户姓名。
具体解释如下:
1. `select distinct S.customer_name`:选择不同的客户姓名,以避免重复。
2. `from depositor as S`:从“存款人”表中选择数据,并将其别名为“S”。
3. `where not exists`:使用“not exists”关键字执行否定的存在性检查。
4. `( (select branch_name from branch where branch_city = 'Brooklyn') except (select R.branch_name from depositor as T, account as R where T.account_number = R.account_number and S.customer_name = T.customer_name ))`:在布鲁克林市开户的所有分行名称与S客户的分行名称进行比较,如果S客户未在任何一个分行开户,则该记录将被选择。
需要注意的是,这个查询语句的具体实现方式可能因数据库系统的不同而有所不同。
SELECT DISTINCT A.BEGIN_REPAIR_NO, A.PART_NO, A.CREATE_BY, B.EMPLOYEE_NAME AS CREATE_NAME, A.CREATE_TIME FROM TPMDATA.PICKING A LEFT JOIN TPMDATA.SAP_EMPLOYEE B ON A.CREATE_BY = B.EMPLOYEE_NO
这是一条 SQL 查询语句,用于查询 TPMDATA 数据库中 PICKING 表中不同的 BEGIN_REPAIR_NO、PART_NO、CREATE_BY 和对应的 CREATE_NAME、CREATE_TIME。其中使用了 LEFT JOIN 关键字,将 TPMDATA.PICKING 表中的 CREATE_BY 字段与 TPMDATA.SAP_EMPLOYEE 表中的 EMPLOYEE_NO 字段关联起来,以便查询对应的 CREATE_NAME。
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.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)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)