written test was easy. Questions was from english and logical reasoning. After Aptitude test I appeared for face to face technical interview. My technical interview duration was 1hrs 15 min approx.He ask me questions like -- 1-nested query in sql,joins,find second and third highest salary by joining two tables. 2-normalization,swaping of three numbers without using third variable 3-sorting questions,string functions, 4-oops concept(abstraction) 5-some coding questions in php 6-some question from codeigniter(such as helper,hooks,mvc etc) 7-explode,implode,pdo,superglobal second round was elemination round

1.Basic php questions. 2.join questions. 3.Star pattern program