How to select an empty result set?

This should work on most DBs, tested on Postgres and Netezza:

SELECT NULL LIMIT 0;

There's a dummy-table in MySQL called 'dual', which you should be able to use.

select
    1
from
    dual
where
    false

This will always give you an empty result.

T-SQL (MSSQL):

SELECT Top 0 1;

Related