A 3-member panel was present to take the interview. Questions were:- Find if a number is prime or not. Add two numbers represented as linked lists. Merge 2 linked lists. Easy to moderate level of questions related to OOPS were asked. Finally, 2 tables were provided and a SQL query to calculate second largest salary was to be written.

Question

Accepted Answer

Answer to find the second largest salary:

select min(salary) from (select distinct(salary) from employee order by salary desc) where rownum<3;

if it asks to find using subquery then:

select max(salary) from employee where salary not in (select max(salary) from employee);

Popular interview questions of Software Engineer Trainee

Top HR questions asked in Nirvana Solutions Software Engineer Trainee