1. He is at school. Right this minute, he is (for instance) in a classroom with a teacher.
2. He is in school. He is a student. He does not have a job, but he is working towards a degree. It can also mean the same as #1 for a child who is too young to have employment.