WDMtech interview questions

written test was easy. Questions was from C Programming and logical reasoning. After Aptitude test I appeared for face to face technical interview. My technical interview duration was 1hrs 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)