SELECT
CASE
WHEN(SELECT COUNT(*) FROM COMMENT C WHERE C.ID=C.PID)>0
THEN 1
ELSE 2
END
AS "是否回复"
FROM COMMENT COM
case
最新推荐文章于 2024-12-12 08:00:00 发布
SELECT
CASE
WHEN(SELECT COUNT(*) FROM COMMENT C WHERE C.ID=C.PID)>0
THEN 1
ELSE 2
END
AS "是否回复"
FROM COMMENT COM