Register

sql doubt
closed

• closed by
800 views
0 0 votes
closed with the note: wrong question.
Given a Relation POSITION (Posting-No, Skill), then query to retrieve all distinct pairs of posting-nos requiring skill is

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

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

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

4. Select p1.posting-No, p2.posting-No from position p1, position p2 where p1.skill = p2.skill;
Voting & Accepting an answer helps improve the community
← Previous · DoubtNext → · sql doubt
← Previous in category · Ace test seriesNext in category → · sql doubt
Position:
Show:

Related questions

0 0 votes
0 0 answers
210
210 views
js__ asked Nov 24, 2025
210 views
Doubt - sql
Should we answer according to the latest version which is in real life practical or stick to the old versions in standard text books ? @Deepak Poonia @Sachin Mittal 1 Que...
0 0 votes
1 1 answer
852
852 views
Shamim Ahmed asked Nov 12, 2018
852 views
SQL self doubt
In this question:-https://gateoverflow.in/8225/gate2015-1-27I am not understanding how the query is returning 2 .I think DISTINCT must be there to give the correct answer...
0 0 votes
1 1 answer
330
330 views
Wren Oswin asked May 22, 2025
330 views
SQL
Table 1T1AT1Baaabbbccc  Table 2T2AT2BT2CaaabanullHow many tuples would the below...
1 1 vote
1 answers 1 answer
1.2k
1.2k views
tishhaagrawal asked Dec 16, 2023
1,177 views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...