CREATE TABLE run_parms
   (
    [FILE_NAME] CHAR(6),
    RUN_IND INT,
    [GROUP] VARCHAR(8)
   )
INSERT   INTO run_Parms
         ([FILE_NAME], RUN_IND, [GROUP])
         SELECT   'FAMABT', 0, 'HOLD'
         UNION ALL
         SELECT   'FAMADF', 0, 'DOC'
         UNION ALL
         SELECT   'FAMALF', 1, 'FIN'
         UNION ALL
         SELECT   'FAMAPF', 1, 'FIN'
         UNION ALL
         SELECT   'FAMARD', 0, 'DOC'
         UNION ALL
         SELECT   'FAMARF', 0, 'DOC'
         UNION ALL
         SELECT   'FAMARH', 0, 'DOC'
         UNION ALL
         SELECT   'FAMATT', 0, 'SEC'
         UNION ALL
         SELECT   'FAMBAF', 1, 'FIN'
         UNION ALL
         SELECT   'FAMBTT', 0, 'TBL'
         UNION ALL
         SELECT   'FAMC1T', 1, 'MISC'
         UNION ALL
         SELECT   'FAMC2T', 0, 'MISC'
         UNION ALL
         SELECT   'FAMCAT', 0, 'COST'
         UNION ALL
         SELECT   'FAMCCF', 1, 'FIN'
         UNION ALL
         SELECT   'FAMCCT', 1, 'HOLD'

/*
How do i check the value for a given group is unique. 
Meaning, here the FIN group has value 1 as its RUN_IND 
so i need to get a result set as 1 if the value is 1 
for all the files for a particular group else it can 
be 0. So here only FIN group should result as 1 and 
other groups should be zero*/

SELECT   [group]
   FROM     run_parms
   GROUP BY [group]
   HAVING   MIN(run_ind) = 1