Two people killed in a US school shooting were a staff member and a student who was probably the attacker, police said.