SQL问题 (100分)

W

wupaul

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #1

我一个表中有两个字段PID和ID
现在我想用SQL找出ID不等于其它记录PID的记录，应该怎样写？

 

W

watter

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #2

Select ID
From Table
where ID not Exists
(Select Pid From Table)

 

H

haiyang2008

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #3

Select * From Table
where ID not Exists
(Select Pid From Table)

 

E

ermao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #4

两种都可以

 

W

wupaul

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #5

多人接受答案了。

 

M

maolu28

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #6

select * from Table
where ID not in (Select Distinct Pid From Table)

good luck