请sql查出version、os 一致的手机号码
表结构如下:
SQL:
SELECT
m.tel,
m.version,
m.os
FROM
mng_user_info m ,
(
SELECT
u.version,
u.os
FROM
mng_user_info u
GROUP BY
u.version,
u.os
HAVING
COUNT( 1 ) > 1
) ss
WHERE
m.version = ss.version
AND m.os = ss.os