How to simulate NO_ROWS, 1 Row and many rows using a single Select

I picked these from the OTN Forums - the queries are surprisingly simple :-

SELECT 'SANDEEP' FROM DUAL WHERE 1 = 2; -- NO_ROWS

SELECT 'SANDEEP' FROM DUAL; -- 1 ROW

SELECT 'SANDEEP' FROM DUAL CONNECT BY LEVEL < 11; -- 10 ROWS