如何找出在标示表中存在3条记录的视频记录? 有查询示例SQL 谢谢 SELECT GuidFROM Pub_VideoWHERE EXISTS (SELECT Guid FROM Pub_Marking WHERE (MKGuid = Pub_Video.Guid))以上SQL是:当前是找出在标示表存有存在记录的视频记录那如何改为找出在标示表中存在3条记录的视频记录?谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT top 3 GuidFROM Pub_VideoWHERE EXISTS (SELECT Guid FROM Pub_Marking WHERE (MKGuid = Pub_Video.Guid))没怎么看懂 SELECT GuidFROM Pub_VideoWHERE EXISTS (SELECT Guid FROM Pub_Marking WHERE (MKGuid = Pub_Video.Guid) HAVING COUNT(guid)=3)还是这样? 请看一下这个简单的SQL 语句.. 大家帮我解释一下这个面试题 这个group by 语句怎么写? SQL 改变 字段类型 出错~ 求一SQL语句 数字这符串的排序问题 sql server默认字符集设置 再用忙看一下触发器的问题。谢 olap之查询语句(select..from..where) 在vfp中怎么用使用命令按钮强行退出正在循环处理的过程 求一条语句 sql2008 语句 ~~~~~~~~~@@IDENTITY返回Null,过来看看,马上给分~~~~~~~~
FROM Pub_Video
WHERE EXISTS
(SELECT Guid
FROM Pub_Marking
WHERE (MKGuid = Pub_Video.Guid))
没怎么看懂
FROM Pub_Video
WHERE EXISTS
(SELECT Guid
FROM Pub_Marking
WHERE (MKGuid = Pub_Video.Guid) HAVING COUNT(guid)=3)还是这样?