select MC.STCODE,MC.STNAME,SUM(MC.TOTAL) TOTAL,'非周末'
from MC_SDRPTSXS MC,FASOLARTOLUNAR FA
where MC.FILDATE=FA.SOLARDATE AND exists (select 1
from store
where store.countries = '中国香港' AND CODE LIKE /*VSTCODE ||*/ '000871%'
and MC.stgid = gid)
and fildate>='2016-03-06'
and fildate<'2016-03-17'
AND FA.WEEK not IN ('星期六','星期日')
GROUP BY MC.STCODE,MC.STNAME
与
select MC.STCODE,MC.STNAME,SUM(MC.TOTAL) TOTAL,'非周末'
from MC_SDRPTSXS MC,FASOLARTOLUNAR FA,store
where MC.FILDATE=FA.SOLARDATE AND store.countries = '中国香港' AND CODE LIKE /*VSTCODE ||*/ '000871%'
and MC.stgid = gid
and fildate>='2016-03-06'
and fildate<'2016-03-17'
AND FA.WEEK not IN ('星期六','星期日')
GROUP BY MC.STCODE,MC.STNAME
这两个有啥不一样,那个更好点?
from MC_SDRPTSXS MC,FASOLARTOLUNAR FA
where MC.FILDATE=FA.SOLARDATE AND exists (select 1
from store
where store.countries = '中国香港' AND CODE LIKE /*VSTCODE ||*/ '000871%'
and MC.stgid = gid)
and fildate>='2016-03-06'
and fildate<'2016-03-17'
AND FA.WEEK not IN ('星期六','星期日')
GROUP BY MC.STCODE,MC.STNAME
与
select MC.STCODE,MC.STNAME,SUM(MC.TOTAL) TOTAL,'非周末'
from MC_SDRPTSXS MC,FASOLARTOLUNAR FA,store
where MC.FILDATE=FA.SOLARDATE AND store.countries = '中国香港' AND CODE LIKE /*VSTCODE ||*/ '000871%'
and MC.stgid = gid
and fildate>='2016-03-06'
and fildate<'2016-03-17'
AND FA.WEEK not IN ('星期六','星期日')
GROUP BY MC.STCODE,MC.STNAME
这两个有啥不一样,那个更好点?
解决方案 »
- 关于访问数据表的问题
- 求教 SQL 2005 迁移到 oracle10g
- 删除oracle数据,oracle在那儿可以找到谁删除的吗
- 大家给个意见
- 使用存储过程完成级联删除的问题
- 在Oracle9i里面怎样创建数据库和数据表?
- 高手请赐教。如何才能把可变的 字符串 传到PROCEDURE 的程序里呢。
- 重金缉拿ORACLE书籍,同时开ORACLEQQ群,号码是5226727,欢迎大家光临!尤其是高手指导!
- 请问如何启动 Oracle management server?
- 这条SQL该怎么写?
- 数据量大表inner join,有办法优化吗?
- oracle的smart flash cache支持redhat 6.5系统吗
select 1,
select *,
select PK都一样,不用过于关注这些;