How to select an empty result set?

sql mysql stored-procedures null resultset

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

select    1from    dualwhere    false

This will always give you an empty result.

sql mysql stored-procedures null resultset

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

SELECT NULL LIMIT 0;

sql mysql stored-procedures null resultset

T-SQL (MSSQL):

SELECT Top 0 1;

CodeHunter