SQL Query

  
Household Individual 101 11 101 12 101 13 101 14 101 15 102 1 102 2 102 3 102 4 I need a sql query to get number of Household with more than 4 individuals. In the above table household 101 have more than 4 individual. So here the extract should be 1.
I'm assuming you just have one field, a household number (101, 102, etc.).  There are 14 household 101 records, 4 household 102 records, etc.  If that is correct, try the following.

SELECT     HouseholdNumber, COUNT(*) AS HouseCount, '1' AS OverFour
FROM         Household
GROUP BY Household
HAVING      (COUNT(*) > 4)

This returns three fields - HouseholdNumber = 101, HouseCount = 14 and OverFour = 1

Hope this helps,
Curt