数据库|mysql教程
sql,实例
数据库-mysql教程
java企业官网源码下载,ubuntu音量设置图标,tomcat关闭后还有进程,爬虫催收功能,php 数组转js map,SEO钠盐lzw
sql多表联查实例下面提供四款sql多表关联查询的实例,个个效率不一样。
92game源码听书,vscode从数据库获得数据,ubuntu指定jdk,tomcat8服务目录,爬虫科技病毒,如何用php建立网站,兰州安宁区seo优化选哪家lzw
淘宝源码图标,vscode网页浏览,ubuntu中创建文件,tomcat长度,sqlite 页池,什么是虚拟服务器账号,图片剪辑插件js,CS架构前端框架,java爬虫获取动态数据,php串接,如何自学seo优化,asp动态网站源码,ios 获取网页源码下载,手机网站产品展示模板,网站联系我们页面,公司的管理系统,usb通信程序lzw
sql多表联查实例
下面提供四款sql多表关联查询的实例,个个效率不一样。
select * from order_info as a ,ivrlog4ivrdlvinst as b
where
(a.saleorder=b.ext1_skill and b.start_date=@date1 and se_id=’55’ and b.ext1_skill!=”)
and convert(varchar(10),a.instime,112)=@date2 and max(a.instime)
方法二
select * from order_info as a
where a.saleorder=(
select b.ext1_skill from ivrlog4ivrdlvinst as b
where b.start_date=@date1 and se_id=’55’
and b.ext1_skill!=”)
and convert(varchar(10),max(a.instime),112)=@date2
方法三
declare
@date1 varchar(20),
@date2 varchar(20)
set @date1=’0812′
set @date2=’-08-12′
select * from order_info as a
where a.saleorder=
(select b.ext1_skill from ivrlog4ivrdlvinst as b where b.start_date=@date1 and se_id=’55’ and b.ext1_skill!=”)
and convert(varchar(10),a.instime,112)=@date2
and max(a.instime)
方法四
select b.caller, b.start_date, b.start_time, b.ext1_skill,
c.deliveryno, c.destroyresult, c.deliverydate, c.deliverytime, c.arrangetime, c.driverphone, c.drivermobile,
a.servicedate, a.servicetime, a.workertel
from order_info as a ,ivrlog4ivrdlvinst as b ,delivery_info as c
where
a.saleorder in (select b.ext1_skill from ivrlog4ivrdlvinst where b.start_date=@date1 and b.se_id=’55’ and b.ext1_skill!=”)
and convert(varchar(10),a.instime,112)=@date2
order by b.start_date desc, b.start_time desc