subquery_where_compare_all.sql

AbsDataBase5.16 最新版

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This example illustrates use of keyword ALL in where clause. 
  This query returns events that will occur on venues with capacity lower than in venues 3 and 4.*/

select e1."Event_Name", v2."Capacity"
  from "events" e1, "venues" v2
 where (e1."VenueNo" = v2."VenueNo") and
       (v2."Capacity" < all (select v."Capacity" from "venues" v where v."VenueNo" between 3 and 4))