Process took around 3 weeks.
Online test: aptitude, verbal, logical + 2 coding questions. Mine were pattern printing and reverse a string without using inbuilt functions. Easy if you practise with time limit.
Technical: started with my project (about 15 min), then OOP with examples, difference between C and C++, and a SQL query on paper - second highest salary. He asked "any other way?" two times so know at least 2-3 ways.
HR: relocation, why Wipro, ok with bond or not.
Got selected mail last week 🎉
for people reading, 3 ways for 2nd highest:
1. ORDER BY salary DESC LIMIT 1 OFFSET 1
2. SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM emp)
3. DENSE_RANK() and filter rank 2
1 breaks when top 2 salaries are same, 2 and 3 handle that
Congrats Nandini! They did the "any other way" thing to me also
@Nikhil yes he asked exactly about duplicates for the LIMIT one
congrats didi 🙌
Structured lessons on DSA, core CS, Java and interview skills, each ending in a quiz so you know it stuck.