SQL 置顶新增的数据

最新推荐文章于 2023-11-27 09:43:28 发布

f7anty

最新推荐文章于 2023-11-27 09:43:28 发布

阅读量507

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/F7ANTY/article/details/81181635

版权

SQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

置顶新增的project_building_floor数据，表的关系如下

SQL如下

select f.id,f.name,f.floor_no,f.status,p.name as project_name,b.name  as building_name,f.create_time,f.project_id,f.building_id
from  project_building_floor f 
inner join project_building b ON b.id = f.building_id AND b.del_flg=1
inner join project p ON p.id = f.project_id AND p.del_flg=1
where f.system_id=19 
order by 
case when f.project_id=(SELECT project_id from project_building_floor order by id desc limit 1) 
then 0 else 1 end,f.project_id ,f.building_id, f.floor_no