Pergunta de entrevista da empresa OneDirect (India)

How do you replace the data from two columns in a single SQL query?