We were called at 11 & panel came after that. There were more than 30 people. Only 2 or 3 people were taking interviews. 1st round happened at 4PM (waited 5 hours).
The lady who was taking interview, took almost 45minutes for all the interviewees. But post lunch she was completing it in 10minutes for everyone.
She asked me about removing duplicates from table.
I wrote a query using ROWID, which she was not aware of. She said it can only be done using HAVING clause.
I wrote that as well.
But looks like they already made their mind or maybe the lady was out of her mind.
DUMB INTERVIEWER.
I am glad I am rejected because a person like me, would prefer working with more knowledgeable people & not dumbos like her.
She was also not aware about the difference between ANSI & Oracle SQL 😂
NOTE: Always ask questions to the interviewer.