11031
Drew| 30 |104
zombiechick | 3 |159
(4 rows)
Thanks for your help!
Eric L. Blevins
- Original Message -
From: "Oliver Elphick" <[EMAIL PROTECTED]>
To: "Eric L. Blevins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: We
On Wed, 2002-10-16 at 19:26, Eric L. Blevins wrote:
> I've got 2 SQL statements I would like to combine into one.
...
> statement 1: SELECT uid, count(uid) FROM triangulated WHERE uid != 'anonymus' AND
>uid
> != 'anonymous' AND uid != '' GROUP BY uid ORDER BY count DESC LIMIT 10;
...
> statemen
SELECT * FROM Payments P1 WHERE Date = (SELECT MAX(Date) FROM Payments P2
WHERE P2.CustomerNo = P1.CustomerNo)
I think that will do it.
- James
- Original Message -
From: "Henry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]@postgresql.org>
Sent: Saturday, July 14, 2001 3:16 PM
Subject: [SQ
