常用的几种sql查询语句

最新推荐文章于 2024-07-14 00:13:14 发布

莫再讲

最新推荐文章于 2024-07-14 00:13:14 发布

阅读量3k

点赞数 2

文章标签： sql

本文链接：https://blog.csdn.net/weixin_38379125/article/details/78696693

版权

sql="select username,psw,gname,tel from (t1 left join t2 on t1.t1_id=t2.t1_id) left join t3 on t1.t1_id=t3.t1_id"

select a.name,b.email from a,b where a.nameid=b.nameid and a.fenleiid=3

select * from student inner join teacher on student.id=teacher.sid inner join project on student.id=project.sid;

select a.name,b.email from ainner join b on a.nameid=b.nameid where a.fenleiid=3

select a.name,b.email from a,b where a.nameid=b.nameid and a.fenleiid=3

表1：strcd, amt, fee, date, valide
表2：strcd，strname, string
表3: strcd, addr, tel, person
想查询得到某个date的
strcd，strname, addr, amt, date
该怎么写这句SQL语句

select a.strcd, b.strname, c.addr, a.amt，a.date
from (tb1 a left join tb2 b on a.strcd=b.strcd) left join tb3 c on a.strcd=c.strcd
where date='2010-6-10'
order by strcd

<select id="query" parameterType="map" resultType="Desk">
        select * from desk
        <where>
            <include refid="query_desk_where"/>
        </where>
        limit ${(pc-1)*ps},${pc*ps}
    </select>

<select id="query" parameterType="map" resultType="Desk">
        select * from desk
        <where>
            <include refid="query_desk_where"/>
        </where>
        limit #{pc-1}*#{ps},#{pc}*#{ps}
    </select>

<update id="batchUpdateLoginTime" parameterType="pubUserEmployee">
    UPDATE pub_user_employee SET startHour=#{startHour},startMinute=#{startMinute},
        endHour=#{endHour},endMinute=#{endMinute},loginCycle=#{loginCycle}
    WHERE sysEmpId IN (
    <foreach item="p" collection="sysEmpIds" separator=",">
        #{p}
    </foreach>
    ) AND comId = #{comId};
</update>