2 votes 2 votes Given a Relation POSITION (Posting-No, Skill), then the query to retrieve all distinct pairs of posting-nos. requiring skill is Select p.posting-No, p.posting-No from position p where p.skill=p.skill and p.posting-No < p.posting-No Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$ where p$_1$.skill=p$_2$.skill Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$ where p$_1$.skill=p$_2$.skill and p$_1$.posting.No < p$_2$.posting-No Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$ where p$_1$.skill=p$_2$.skill and p$_1$.posting.No = p$_2$.posting-No Databases ugcnetcse-dec2012-paper2 databases sql + – go_editor asked Jul 11, 2016 • retagged May 25, 2020 by Arjun go_editor 3.0k views answer comment Share Follow See 1 comment See all 1 1 comment reply focus _GATE commented Jul 11, 2016 reply Follow Share Is its option are correctly typed ?? 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes Ans is C Sanjay Sharma answered Jul 13, 2016 Sanjay Sharma comment Share Follow See 1 comment See all 1 1 comment reply anchitjindal07 commented Sep 8, 2018 reply Follow Share Sir. I could not understand question. Is it incomplete 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes It should be p1.skill = p2.skill AND p1.posting no <> p2.posting no.. Digvijay Pandey answered Jun 23, 2015 Digvijay Pandey comment Share Follow See 1 comment See all 1 1 comment reply Shimpy Goyal commented Jun 23, 2015 reply Follow Share but ans is c not getting how 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes answer is C we need to join position with itself based on skill then it is given distinct pairs so we need to consider only p1.position-no < p2.position-no Sankaranarayanan P.N answered Aug 19, 2016 Sankaranarayanan P.N comment Share Follow See all 0 reply Please log in or register to add a comment.