You can also have a subquery in from as in

    select * from (select 1) as temp;