Re: where not unique

You're right, Reinoud. Sorry for my mystake...

Reinoud van Leeuwen wrote:

>On Fri, Mar 12, 2004 at 10:54:25AM -0300, Daniel Henrique Alves Lima wrote:
>  
>
>>Gary Stainburn wrote:
>>
>>    
>>
>>>Hi folks,
>>>
>>>I've got a table which contains amongst other things a stock number and a 
>>>registration number.  I need to print out a list of stock number and reg 
>>>number where reg number is not unique (cherished number plate transfer not 
>>>completed).  I've tried variations of a theme based on 
>>>
>>>select stock_number, registration from stock where registration in 
>>> (select registration, count(registration) as count 
>>>    from stock where count > 1 group by registration);
>>>
>>>but I have two problems.  Firstly with the sub-select I get:
>>>
>>>usedcars=# select registration, count(registration) as count from stock where 
>>>count > 1 group by registration;
>>>ERROR:  Attribute 'count' not found
>>>usedcars=#
>>>
>>>although if I miss out the where clause I get the expected results.
>>>
>>>      
>>>
>>    I think that this is not the best way, but :
>>
>>select * from (select registration, count(registration) as counter from 
>>stock group by registration)
>>where counter > 1;
>>    
>>
>
>Isn't that the same as
>
>select registration
>from stock
>group by registration
>having count (registration) > 1;
>
>
>  
>