ZS Associates Interview Question

sql joins rank vs dense rank