Re: query help

hello
i add more column not row for new user. i want all "last like 'J%'".
http://www.nabble.com/an-other-provokative-question---tf4394285.html
sincerely
siva

-------- Original Message --------
Subject: Re: [GENERAL] query help
From: "Alexander Staubo" <alex@purefiction.net>
Date: Thu, September 13, 2007 11:17 am
To: "volunteer@spatiallink.org" <volunteer@spatiallink.org>
Cc: pgsql-general@postgresql.org

On 9/13/07, volunteer@spatiallink.org <volunteer@spatiallink.org> 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/