How to get an empty resultset

[pando]

select * from X where 1 = 0 always worked for me

where rownum < 1 as well

[Edited by pando on 10-18-2001 at 03:47 AM]