案例:
SELECT * FROM loupandengji ;
数据源
需求:
找出每个“楼盘”最后更新的一条记录。
SQL:
SELECT
*
FROM
( SELECT * FROM loupandengji having 1 order by modify_time desc,loupan_name asc) AS b
GROUP BY
loupan_name
记录生活,记录美好
案例:
SELECT * FROM loupandengji ;
数据源
需求:
找出每个“楼盘”最后更新的一条记录。
SQL:
SELECT
*
FROM
( SELECT * FROM loupandengji having 1 order by modify_time desc,loupan_name asc) AS b
GROUP BY
loupan_name
本页的评论功能已关闭