Bissoy.com
Doctors Medicines MCQs Q&A

  1. WHERE P1.capacity >= All (select P2.capacity from Cinema P2)
  2. WHERE P1.capacity >= Any (select P2.capacity from Cinema P2)
  3. WHERE P1.capacity > All (select max(P2.capacity) from Cinema P2)
  4. WHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)
4 views

1 Answers

Option 1 : WHERE P1.capacity >= All (select P2.capacity from Cinema P2)

SELECT P1.address

FROM Cinema P1

WHERE P1. Capacity > = All (select P2. Capacity from Cinema P2)

The above query will find the addresses of theatres with maximum capacity.

4 views

Related Questions