视图查询问题? select a.no,m,n,x,y from a,bwhere a.no = b.no and a.atime = (select min(atime) from a) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.no,m,n,x,y from a,bwhere a.no = b.no and a.atime = (select max(atime) from a) select a.*,b.x,b.yfrom(select no,m,n from A表 a where atime=(select max(atime) from A表)) a join B表 b on a.no=b.no 帮我看看这条SQL语句怎么修改一下效力会高些? 怎么可以推算年份? SQL Server 2005&2008备份与恢复 II mssql 替换问题 双引号无效 急啊,请教高手 求sql语句,急!!! sql 2008r2连接不上windows sqlserver批量安装 如何将五个表用Left Join得到的查询结果进行筛选? 新手请教各位前辈:怎么在数据库里存储音乐文件,图片文件? sql server 無法運行 次处有错~~~~~~~求助 【新手提问】这样的SQL语句怎样写?
where a.no = b.no and a.atime = (select max(atime) from a)
from(
select no,m,n from A表 a where atime=(select max(atime) from A表)
) a join B表 b on a.no=b.no