Question

sql server 2005查询一个表中两列值相等的sql语句怎么写?

Answer 1

select * from 表 where 列1=列2

或者select * from A A1 INNER JOIN A A2 ON A1.列1=A2.列2

Answer 2

select * from 表 where 列1=列2

Answer 3

select 列1 from 表 where 列1=(select 列2 from 表)

Answer 4

等值连接 select * from A join B where A.列1=B.列2
A B 表 是同一张表

Answer 5

用自连接 也可以的