Xoriant Interview Question
The interviewer asked various questions from java core concepts, OOPS, etc. One question that struck me was he made write a query which was, given two tables Student and Coordinator, and a column which is common between them, retrieve the coordinator data using the given student ID.
Interview Answer
Anonymous
Aug 13, 2020
I suggested a nested query(which is time complex, but since the interviewer asked about only that student, I couldn't think of anything else at the time), but he then "corrected me"by saying we need to use SELF JOIN, to get related data from two tables, and then hurriedly cut the call without letting me ask any questions or queries.