Re: Select * from ( Select etc..)

Jeffery L Post <postjeff@uwm.edu> writes:
> I am just wondering how I can select from a generated dataset.

Use 7.1.

> ex.
>   Select * from (
>     select first, last from staff where salary > 12000
>    union
>     select first, last from staff where salary < 50000
>    )
>   order by last

... although this example is not exactly compelling, since you could
just write

    select first, last from staff where salary > 12000
   union
    select first, last from staff where salary < 50000
   order by last

            regards, tom lane