Re: Simple (hopefully) query question
Date: Thu, 7 Feb 2008 22:14:25 +0100
Message-ID: <47ab74bc$0$85786$e4fe514c@news.xs4all.nl>
<fitzjarrell_at_cox.net> schreef in bericht
news:46eaf728-d37c-4b8c-934f-662495d16fed_at_e23g2000prf.googlegroups.com...
On Feb 6, 2:22 pm, TonyV <kingskip..._at_gmail.com> wrote:
> Hey all, I'm having a problem with what should be a simple query. I
> don't know if my brain is fried today or what, but hopefully the
> following simple example will explain what I'm trying to do:
>
> -- Does NOT work
> select col_name, col_count
> from (
> select column1 "col_name", count(column1) "col_count"
> from table_name
> group by column1
> )
> where col_count > 1;
>
> When I try to run this, I get dinged with a 904 error, invalid
> identifier.
>
> My question is this: How can I select the name and count of something
> where the count is greater than one?
Use group by and having:
select column1 "col_name", count(column1) "col_count"
from table_name
group by column1
having count(column1) > 1;
David Fitzjarrell
Works too, even better.....
The cause of the error however were the quotes....
Shakespeare Received on Thu Feb 07 2008 - 15:14:25 CST