I have one teacher table containing school code,teacher details like sex,name etc.I want to count those schools having only male teachers(ie no female teachers).Bcoz corresp to one school there can be multiple records.Its very urgent.Pls help me if somebody has soln?(i need the SQL query full code)

kshivani
Profile Answers by kshivani Questions by kshivani
May 2nd, 2006
4
1571

Showing Answers 1 - 4 of 4 Answers

kishore_11210
Profile Answers by kishore_11210

May 2nd, 2006

hi,
SELECT COUNT(DISTINCT(SchoolID)) FROM TeacherTable WHERE TeacherSex = Female

sajid mohammadi

May 4th, 2006

select distinct schoolcode from teacher where schoolcode not in ( select schoolcode from teacher where sex='female')

namita

May 12th, 2006

select count(distinct schoolcode) from ( select schoolcode from teacher where sex <> 'female') ;

Annapurna

Sep 20th, 2006

select (rowid) count*(distinct schoolcode)
    from ( select schoolcode(rowid)
               from teacher
                  where sex != 'female') ;