Register

Predict the output of given SQL query

• edited by
1,898 views
3 votes
3 votes

Tables are : COUNTRY (CODE, NAME) and MEMBER (ORGANIZATION, COUNTRY_code). primary keys are in blod letters and foreign key is in italics.

SELECT COUNTRY.name
FROM COUNTRY
JOIN member
ON COUNTRY.code= member.COUNTRY_code
WHERE member.ORGANIZATION =ALL(SELECT organization
FROM member
WHERE
member.COUNTRY_code=COUNTRY.code )

What wil be the output of given SQL query?

1. List the names of countries which are members of at least one organisation.

2. List the names of countries which are members of only one organisation.

3. List the names of countries which are members of one or more organisations.

4. List the names of countries which are members of all  organisations.

• edited by
User Avatar

2 Answers

2 votes
2 votes
bro I think answer is B) only one org will be equal to inner sub query.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
2 answers
1
sh!va asked Jan 30, 2017
3,151 views
Predict the result of SQL query
Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric unique(Emp_id,Name)); What will be the result of the query? insert into Employee values(1002, 'Ross', 'CSE', 10000) ... ;Ted','Finance', ); d) Error in insert into Employee values(1008,'Ross','Sales',20000);
Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric unique(Emp_id,Name));What will be the result of the query?insert i...
User Avatar
3 votes
3 votes
2 answers
2
shikharV asked Dec 8, 2015
1,158 views
Output of given sql query
Use the following tables for the below queries wherever table $1$ and table $2$ are used: Select * From Table 1 Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B < > T_{1}B$) How many number of rows will be there in the output ? $1$ $2$ $3$ $0$
Use the following tables for the below queries wherever table $1$ and table $2$ are used:Select *From Table 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...
User Avatar
0 votes
0 votes
1 answer
3
shikharV asked Dec 8, 2015
398 views
Finding output of given SQL query
Given answer: B I don't know how to deal with NULL in such query operations. Please explain.
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
User Avatar
0 votes
0 votes
1 answer
4
shikharV asked Dec 8, 2015
1,050 views
Finding output of given SQL query
Given answer: B I don't know how to deal with NULL in such query operations. Please explain.
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
User Avatar
Link Copied!