Adam,

add   having count(*) > 10
after the group by clause.

Hope this helps,

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <00E030047C22D411867B0008C791E72069061D AT ccxmbcls02.conagra DOT cag>, on 
09/20/00
In <00E030047C22D411867B0008C791E72069061D AT ccxmbcls02.conagra DOT cag>, on 
09/20/00
   at 01:25 PM, "Crump, Adam (CC-MIS Open Sys)" <Adam.Crump AT CONAGRA DOT COM> 
said:

>I am trying to list the number of inactive versions of a file if more than
>ten exist.
>Here is what I have so far:

>select FILESPACE_NAME,HL_NAME,LL_NAME,count(*) as Inactive_Files from
>backups where node_name='NODEX' and state='INACTIVE_VERSION' group by
>HL_NAME,LL_NAME,FILESPACE_NAME

>Here is the output:

>FILESPACE_NAME       HL_NAME              LL_NAME
>INACTIVE_FILES
>------------------   ------------------   ------------------
>--------------
>/                    /
>3
>/home                /
>12
>/images              /
>2
>/sa                  /
>1
>/sa/ca               /
>1
>/tng/cac             /
>1
>/tmp                 /                    .oslevel.mlinfo.c-
>1
>                                           ache
>/                    /                    .rhosts
>3
>/                    /                    .rhosts_bak
>3
>/tmp                 /                    .sf27036
>1
>/                    /                    .spgen_rhosts
>3
>/tmp                 /                    .strload.mutex
>1


>My question is what do I code now to only get the entry if more than ten
>exist (I don't want to see all the entries that only have one inactive
>version). I have tried using count(*) > 10, but that doesn't work.