A SELECT that returns one (or more) constant values without a FROM clause.

select 42;

or

select 'Found something!'
where exists (select 1 
              from customers 
              where zip_code = '12345')
  or exists (select 1 
             from orders
             where amount > 42);

Back to the SQL Feature Comparison