subquery_where_compare_any.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 10 行

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

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