sql学习

最新推荐文章于 2021-08-20 18:56:42 发布

VictoryVivan

最新推荐文章于 2021-08-20 18:56:42 发布

阅读量408

点赞数

分类专栏：随记文章标签： sql

本文链接：https://blog.csdn.net/qq_24057133/article/details/51094641

版权

随记专栏收录该内容

25 篇文章 0 订阅

订阅专栏

查询不重复的某项

<select id = "ServiceComBoList" resultMap="BaseResultMap">
        select   distinct  office   from T_B_SERVICESTATION
    </select>

关联多表有条件查询

 <select id="queryByConditions" resultMap="BaseResultMap" parameterType="java.lang.String">
        select distinct z.ID,z.CAR_TYPE  from (
                   select a.CAR_TYPE ,a.ID 
                   from T_B_CHECKING_ITEM a 
                   left join T_B_USER b 
                   on a.CREATE_USER = b.ID where a.STATE = 1
                   ) z 
              left join T_B_USER b1
              on z.UPDATE_USER = b1.id
              <where>
                <if test="_parameter != null and _parameter!=''" >
                    AND z.CAR_TYPE LIKE '%${_parameter}%'
                </if>
            </where>
            order by CREATE_TIME desc
    </select>