SELECT (SELECT COUNT(*)
FROM seginfo
WHERE holeid = a.holeid) AS segcount
FROM HoleInfo a
WHERE (segcount > 0) 提示segcoun列名无效怎么解决呢?
FROM seginfo
WHERE holeid = a.holeid) AS segcount
FROM HoleInfo a
WHERE (segcount > 0) 提示segcoun列名无效怎么解决呢?
as segcount
FROM HoleInfo a
apply (SELECT COUNT(*) segcount
FROM seginfo
WHERE holeid = a.holeid) b
WHERE (b.segcount > 0)
SELECT HoleName,
(SELECT COUNT(*)
FROM seginfo
WHERE holeid = a.holeid) AS segcount
FROM HoleInfo a
WHERE (segcount > 0)
SELECT (SELECT COUNT(*)
FROM seginfo
WHERE holeid = a.holeid) AS segcount
FROM HoleInfo a
WHERE (segcount > 0)--这样查询的条件要在外边套一层
--楼主可以这样!
select count(*) as segcount
from HoleInfo a left join seginfo b on a.holeid = b.holeid
group by a.holeid
having count(*) > 0
SELECT HoleName,
(SELECT COUNT(*)
FROM seginfo
WHERE holeid = a.holeid) AS segcount
FROM HoleInfo a
WHERE (segcount > 0)
WHERE (segcount > 0) 这句判断执行在标量子查询之前,所以你的那个AS segcount 不能用于前面的where
你是不這樣的意思
表 tickets(badge,tick_no)select badge,count(badge) from tickets group by badge having count(badge)>2
FROM HoleInfo a LEFT OUTER JOIN
SegInfo b ON a.HoleID = b.HoleID
GROUP BY a.HoleID, a.HoleName, a.SiteName
HAVING (COUNT(*) > 0) AND (a.SiteName = 'AGL1')
这样就可以了