distinct 必须放在select 后面第一位

最新推荐文章于 2022-10-29 16:06:39 发布

青~

最新推荐文章于 2022-10-29 16:06:39 发布

阅读量1.4k

点赞数

分类专栏：数据库文章标签： sql 数据库

本文链接：https://blog.csdn.net/super_qing_/article/details/122669125

版权

数据库专栏收录该内容

54 篇文章 2 订阅

订阅专栏

distinct 必须放在select 后面第一位

例：正确例子

SELECT distinct t1.school_id,'107', '校长办公室', '0', '2', '', '', 1,
 NULL, NULL, NULL, NULL, NULL, 1, NULL from edu_cloud_school t1 
left join edu_cloud_department t2 
on t1.school_id=t2.school_id where t2.school_id is null

错误例子：

SELECT '107', '校长办公室', '0', '2', '', '', 1, NULL, NULL,
 NULL, NULL, NULL, 1, NULL from edu_cloud_school t1，distinct t1.school_id
left join edu_cloud_department t2 
on t1.school_id=t2.school_id where t2.school_id is null