At 12:00 PM 20-09-02 +0000, you wrote:

>Hi
>
>Can I do something like:
>
>Select Count(*) from (Select * from TABLE1 where FIELD=180);

No - but why would you want to?

Won't this give you the answer you want?

select count(*) from table1 where field=180

heLen