Question

如何在一张表中查找不同记录中的2个相同的字段值 查找PID=ID的sql语句

是把这2条以ID为2的那条PID等于 ID为1的那条的ID为条件 关联起来

Answer 1

select * from biao where id=(slect Pid From biao where 条件)

Answer 2

sqlserver:

select a.*,b.* from talbe as a left join table as b on a.id=b.pid

Answer 3

select t1.* from table t1,table t2 where t1.id=t2.pid

Answer 4

select 字段名
where PID=id1 or PID=id2

Answer 5

建一张临时表，然后循环比对