Given a Relation POSITION (Posting-No, Skill), then query to retrieve all distinct pairs of posting-nos requiring skill is

Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No = p2.posting.No

Select p.posting-No, p.posting-No from position p where p.skill = p.skill and p.posting-No < p.posting-No

Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill

Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No < p2.posting-No

Given a Relation POSITION (Posting-No, Skill), then query to retrieve

1.	Given a Relation POSITION (Posting-No, Skill), then query to retrieve all distinct pairs of posting-nos requiring skill is
A.	Select p.posting-No, p.posting-No from position p where p.skill = p.skill and p.posting-No < p.posting-No
B.	Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill
C.	Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No < p2.posting-No
D.	Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No = p2.posting.No
Answer» D. Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No = p2.posting.No