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 kombination of
field1 :
tabel B
field1, field2, field3
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 kombination
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
I want to
Dear all,
HELP me
PLZ
I'm used this SQL command :
SELECT ean FROM icitem WHERE ean in
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
'
;
-Original Message-
From: ali nas [mailto:[EMAIL PROTECTED]
Sent: Thursday, 31 May 2007 18:57
To: Phillip Smith
Subject: Hal: [SQL] ASK about SQL
YES, I don'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
