On Wed, Aug 19, 2009 at 05:17:07PM +0700, Otniel Michael wrote:
>Hi All.
>
>Can help to create sql queries for this data :
>
>tabel A
>field1, field2, field3
>x1, y1, 5
>x1, y2, 1
>x2, y1, 2
>x2, y3, 4
>x1, y3, 4
>
>
In response to Otniel Michael :
> Hi All.
>
> Can help to create sql queries for this data :
>
> tabel A
> field1, field2, field3
> x1, y1, 5
> x1, y2, 1
> x2, y1, 2
> x2, y3, 4
> x1, y3, 4
>
> I want to get 2 record with the max value at field3 for each k
#x27;t care with with ORDER BY clause. beacuse i just want what the
data INPUT as like that the data OUTPUT ,so INPUT listed = OUTPUT listed.
so there isn't way in POSTGRES to do like this ??
----- Pesan Asli
Dari: Phillip Smith <[EMAIL PROTECTED]>
Kepada: ali nas <[EMAIL PROTECT
Do you mean you want it to order it in the same order as you've listed them
in the IN condition?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of ali nas
Sent: Thursday, 31 May 2007 17:57
To: pgsql-sql@postgresql.org
Subject: [SQL] ASK about SQL
Dear all,
