I received an error the first time I sent this so I'm sending it again.
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.
