Computer Sciences > Gate 2015 Set-3 > SQL Query
Consider the following relation

Cinema (theater, address, capacity)

Which of the following options will be needed at the end of the SQL query

SELECT P1. address FROM Cinema P1

Such that it always finds the addresses of theaters with maximum capacity?
A
WHERE P1. Capacity> = All (select P2. Capacity from Cinema P2)
B
WHERE P1. Capacity> = Any (select P2. Capacity from Cinema P2)
C
WHERE P1. Capacity > All (select max(P2. Capacity) from Cinema P2)
D
WHERE P1. Capacity > Any (select max (P2. Capacity) from Cinema P2)

Correct : SQL Query

PROCESSED

Similar Questions

A palindrome is a word that reads the same forwards and backwards. In a game of words, a player has the following two plates painted with letters. From...
#1 MCQ
Which number does not belong in the series below? 2, 5, 10, 17, 26, 37, 50, 64
#4 MCQ
Choose the word that is opposite in meaning to the word “coherent”.
#5 MCQ

Related Topics

SQL query maximum capacity SQL subquery ALL operator GATE Computer Sciences 2015 Database management system find max value SQL GATE 2015 Set-3 Q16 SQL WHERE clause

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: