![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
祥哥哥咩~
木有
展开
-
SQL按指定值排序
SELECT id, seconds FROM tableName ORDER BYCASE WHEN seconds > -1 THEN 0 WHEN seconds = -1 THEN 1 ELSE 2 END, seconds 查询结果:原创 2022-02-08 15:15:00 · 1559 阅读 · 0 评论 -
pgsql多表关联更新
关联t_device与t_dict表更新t_channel表update t_channel cne set parent_name = v_parent_name, camera_type_name=v_camera_type_name from ( select d1.*,d2.device_name v_parent_name, d3.label v_camera_type_name from t_channel d1 left join t_device d2 on...原创 2021-08-24 16:34:14 · 1548 阅读 · 0 评论