Re: the "having" clause

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: toylet (toylet_at_mail.hongkong.com)
Date: 03/08/04 

Date: Mon, 08 Mar 2004 18:24:48 +0800

sorry, I overlookced the parenthesis. Sorry.

toylet wrote:

> 2 where clauses? Are you serious? That's really strange...
>> select * from
>> (select xx.pk, xx.amount, count(*) as recno
>> from tx xx, tx yy
>> where xx.pk>=yy.pk
>> group by xx.pk, xx.amount) X
>> where recno = 1 

-- 
   .~.    Might, Courage, Vision. In Linux We Trust.
  / v \   http://www.linux-sxs.org
/( _ )\  Linux 2.4.22-xfs
   ^ ^    6:24pm up 2 days 2:34 load average: 1.00 1.00 0.97

Relevant Pages