Hi GSivakumar, and welcome to English Forums. Whether you are talking about the school, the library, that restaurant, or an airport, the difference between "in" and "at" is the same. Use "in" to mean physically inside the building, and use "at" to mean the general area of the building, which could mean inside or simply nearby.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.