我这个查询有什么问题? select count(*) from (select distinct ycdate, misec, facno, channel FROM yc_record)t 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 要将ycdate 与 ycdate, misec, facno, channel比较当然没法比了 thank you ,我SQL语句不熟,多谢 SELECT COUNT(*) FROM (SELECT DISTINCT ycdate, misec, facno, channel FROM yc_record) WHERE ycdate IN (SELECT DISTINCT ycdate, misec, facno, channel FROM yc_record)? select count(*) from (select distinct ycdate, misec, facno, channel from yc_record) SELECT COUNT(*) from yc_record AWHERE Exists (SELECT DISTINCT ycdate, misec, facno, channel FROM yc_record B on A.ycdate=B.ycdate) 求T-SQL语句,高分反馈 一个表可以建立几个存储过程 写一个模糊搜索的存储过程 求SQL数组查询 [100分请教]不使用事务如何保证数据的一致性 多表查询,如何取并集 如何删除一个存储过程? 帮我把这条sql语句简化一下 SQL多对多的关联 100分求:用T-SQl语句能备份和恢复指定的表吗?谢谢 能不能有这样的Sql 锁问题
比较当然没法比了
(SELECT DISTINCT ycdate, misec, facno, channel
FROM yc_record)
FROM yc_record)?
WHERE Exists (SELECT DISTINCT ycdate, misec, facno, channel
FROM yc_record B on A.ycdate=B.ycdate)