SQL denormalization, right function in SQL server, constraints in SQL, types of indexes
Coding challenge :
Count no of employees first name contains 'e' and last name having more than 5 letters
select count(*) from employees where first name like '%e%' and length(last name)5;
Second challenge:
Based on inner join, group by, order by clauses

Question

SQL denormalization, right function in SQL server, constraints in SQL, types of indexes
Coding challenge :
Count no of employees first name contains 'e' and last name having more than  5 letters
select count(*) from employees where first name like '%e%' and length(last name)>5; 
Second challenge:
Based on inner join, group by, order by clauses

Mitratech

Mitratech interview question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches