1.
SELECT
typeName,
NAME,
money,
down_Url,
plug1.*
FROM
plug1
WHERE
NAME IN (
SELECT
NAME
FROM
(
SELECT
count(*) AS cishu,
NAME,
typeName
FROM
plug1
GROUP BY
NAME,
typeName
) t
WHERE
t.cishu > 1
)
ORDER BY
NAME,
typeName
2 在1 基础再套一层
SELECT
*
FROM
(
SELECT
typeName,
NAME,
money,
down_Url
FROM
plug1
WHERE
NAME IN (
SELECT
NAME
FROM
(
SELECT
count(*) AS cishu,
NAME,
typeName
FROM
plug1
GROUP BY
NAME,
typeName
) t
WHERE
t.cishu > 1
)
ORDER BY
NAME,
typeName
) t
WHERE
t.money <> '试用'
OR t.money <> '免费'
mysql 嵌套查询
最新推荐文章于 2024-08-08 22:52:15 发布