Q50,paper2,d 12,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 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©