Pregunta de entrevista de EXL Service

SQL questions regarding distinction between two similar syntaxes.