On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello
>
> table is
> +-------+-------+------+-------+
> |  id   |  one  | two  | three |
> +-------+-------+------+-------+
> | first | Jack  | Jill | Mary   |
> | last  | Ja | Ji  | Ma |
> +-------+-------+------+-------+
>
> result is
> +----+-------+-------+
> | id | one | two |
> +----+-------+-------+
> | first | Jack  | Jill |
> | last | Ja  | Ji   |
> +----+-------+-------+
>
> query is??

Unless I am missing something crucial, this is SQL 101:

  select id, one, two from foo;

Alexander.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Reply via email to