Carol, who is an SDET professional has written the following queires. 


A. SELECT Id, EName, E.CompId AS E_CompId, C. CompId AS C_CompId, Model
FROM EmpTable INNER JOIN Computer C ON E.CompId = C.CompId WHERE Deptid='ETA'

B. SELECT Id, EName, E.CompId AS E_CompId, C.CompId AS C_CompId, Model
FROM EmpTable E INNER JOIN Computer C ON E.CompId = C.CompId AND Deptid = 'ETA'


Select correct answer from the following:

Both gives different result
Both gives same result
Query A is invalid
Query B is invalid
Verified Answer
Correct Option - b

To get all Infosys Certified Database and SQL Professional Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram