Adam,
add having count(*) > 10
after the group by clause.
Hope this helps,
--
--------------------------
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--------------------------
In <[EMAIL PROTECTED]>, on 09/20/00
at 01:25 PM, "Crump, Adam (CC-MIS Open Sys)" <[EMAIL PROTECTED]> 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.
