MAQ Software Interview Question

How self joins are used?