SQL

SQL 查询

查询所有用户最新一笔借款

SELECT * FROM userloans x WHERE createdAt = ( SELECT max( createdAt ) FROM userloans y WHERE x.userPhone = y.userPhone )

此处引用：https://blog.csdn.net/y_z_w123/article/details/80341054?utm_source=blogxgwz1

多表联查

左连接结构：
SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

此处复制：https://www.w3school.com.cn/sql/sql_join_left.asp

示例：
SELECT
cancel.userPhoneNum,
cancel.create_time,
newloan.id,
newloan.createdAt,
newloan.auditStatus,
newloan.transactionStatus
FROM
( SELECT DISTINCT user_phone_num, create_time FROM loancheck WHERE loan_process_type = 8 ) AS cancel
LEFT JOIN (
SELECT * FROM userloans x WHERE createdAt = ( SELECT max( createdAt ) FROM userloans y WHERE x.userPhone = y.userPhone )
) AS newloan
ON cancel.user_phone_num = newloan.userPhone
备注：当前脚本未达到去重效果，查询出的数据会出现部分重复