Ian Barwick <[EMAIL PROTECTED]> writes:
> On Sat, 30 Oct 2004 15:17:16 -0700, Shane Wegner
> <[EMAIL PROTECTED]> wrote:
>> Under MySQL, this query does the trick.
>> select lastname,count(*) as c from names group by lastname
>> having c > 1;
>>
>> Is it possible to do a query like this with Postgr
On Sat, 30 Oct 2004 15:17:16 -0700, Shane Wegner
<[EMAIL PROTECTED]> wrote:
> Hello,
(...)
> I want to retrieve any last names with more than 1
> occurence in the table. Under MySQL, this query does the
> trick.
> select lastname,count(*) as c from names group by lastname
> having c > 1;
>
> But
