mysql 嵌套查询

最新推荐文章于 2025-06-30 10:10:45 发布

原创最新推荐文章于 2025-06-30 10:10:45 发布 · 1.2k 阅读

1 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

79 篇文章

订阅专栏

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 <> '免费'