Re: Simple (hopefully) query question
Date: Thu, 7 Feb 2008 22:14:25 +0100
<fitzjarrell_at_cox.net> schreef in bericht
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
> 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"
group by column1
having count(column1) > 1;
Works too, even better.....
The cause of the error however were the quotes....
Shakespeare Received on Thu Feb 07 2008 - 15:14:25 CST