同意唠叨的。SELECT mobile1 FROM users UNION SELECT mobile2 FROM users 就可以了
SELECT distinct mobile1 FROM users UNION SELECT distinct mobile2 FROM users这样查出来才是唯一的吧,,但是如果这两个里面又有一样的话,,不知道我下面写的语法对不对 (没有调试环境,如果不对,当个思路吧) select xx from ( SELECT mobile1 as xx FROM users UNION SELECT mobile2 as xx FROM users )
select distinct xx from ( SELECT mobile1 as xx FROM users UNION SELECT mobile2 as xx FROM users )如果是mysql好像不行,其他ms-sql-server和oracle都没问题
唠叨老大的说的没错,不用 select distinct xx from ( SELECT mobile1 as xx FROM users UNION SELECT mobile2 as xx FROM users ) 就可以,刚才试过了
FROM users
UNION
SELECT distinct mobile2
FROM users这样查出来才是唯一的吧,,但是如果这两个里面又有一样的话,,不知道我下面写的语法对不对
(没有调试环境,如果不对,当个思路吧)
select xx from
(
SELECT mobile1 as xx
FROM users
UNION
SELECT mobile2 as xx
FROM users
)
(
SELECT mobile1 as xx
FROM users
UNION
SELECT mobile2 as xx
FROM users
)如果是mysql好像不行,其他ms-sql-server和oracle都没问题
select distinct xx from
(
SELECT mobile1 as xx
FROM users
UNION
SELECT mobile2 as xx
FROM users
)
就可以,刚才试过了