Apple Interview Question: The technical questions inclu... | Glassdoor

Interview Question

Software Engineer (Contractor) Interview Cupertino, CA

The technical questions include: - how to prevent sql

  injection - write a sql statement to list all the duplicated entries in a table - give you several tables, and ask you to create foreign keys - use regular expression to replace phone numbers in different format to a single standard format

Interview Answer

1 Answer


select *,count(*) from employee group by fname,lname;

Duplicate entries in say employee table on Mar 30, 2017

Add Answers or Comments

To comment on this, Sign In or Sign Up.