Simple (hopefully) query question

#1

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?

#2

"TonyV" <kingskippus (AT) gmail (DOT) com> schreef in bericht
news:a162f6df-ada4-43ec-a2e9-37c939a80747 (AT) i7g2000prf (DOT) googlegroups.com...

Quote:

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?

Take away the quotes (""). Your column aliases are in lowercase now....

Shakespeare

#3

"TonyV" <kingskippus (AT) gmail (DOT) com> schreef in bericht
news:a162f6df-ada4-43ec-a2e9-37c939a80747 (AT) i7g2000prf (DOT) googlegroups.com...

Quote:

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?

Take away the quotes (""). Your column aliases are in lowercase now....

Shakespeare

#4

"TonyV" <kingskippus (AT) gmail (DOT) com> schreef in bericht
news:a162f6df-ada4-43ec-a2e9-37c939a80747 (AT) i7g2000prf (DOT) googlegroups.com...

Quote:

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?

Take away the quotes (""). Your column aliases are in lowercase now....

Shakespeare

#5

"TonyV" <kingskippus (AT) gmail (DOT) com> schreef in bericht
news:a162f6df-ada4-43ec-a2e9-37c939a80747 (AT) i7g2000prf (DOT) googlegroups.com...

Quote:

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?

Take away the quotes (""). Your column aliases are in lowercase now....

Shakespeare

#6

On Feb 6, 2:22*pm, TonyV <kingskip... (AT) gmail (DOT) com> wrote:

Quote:

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

#7

On Feb 6, 2:22*pm, TonyV <kingskip... (AT) gmail (DOT) com> wrote:

Quote:

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

#8

On Feb 6, 2:22*pm, TonyV <kingskip... (AT) gmail (DOT) com> wrote:

Quote:

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

#9

On Feb 6, 2:22*pm, TonyV <kingskip... (AT) gmail (DOT) com> wrote:

Quote:

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

#10

<fitzjarrell (AT) cox (DOT) net> schreef in bericht
news:46eaf728-d37c-4b8c-934f-662495d16fed (AT) e23g2000prf (DOT) googlegroups.com...
On Feb 6, 2:22 pm, TonyV <kingskip... (AT) gmail (DOT) com> wrote:

Quote:

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