How to select an empty result set?

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.

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

SELECT NULL LIMIT 0;

T-SQL (MSSQL):

SELECT Top 0 1;

How about

 SELECT * FROM (SELECT 1) AS TBL WHERE 2=3

Checked in myphp, and it also works in sqlite and probably in any other db engine.

Related