select count(*) issue with oracle 8i

[cyan01]

Hi, Experts,

I wrote a simple sql:

select count(*), fk1
from tb1
where count(*) < 10 // this line does not work
group by fk1
order by count(*)

Can someone show me how I can do this? Thanks!

 

[SQLSister]

Well I don;t know Oracle, but in SQL Server you need to use a having clause instead of a where clause.

Questions about posting. See faq183-874

 

[PHV]

Condition on aggregate function must be in the having clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244