常用的几种sql查询语句

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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值