Amazon Interview Report
- 0of 0 votes
AnswersWhen you are asked to tune the performance of a SQL query, list the checklist you would do.
- hwei January 07, 2011
Note: you cannot use index.| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersTable:
- hwei January 07, 2011
Order (OrderID, OrderDate)
OrderItem (ItemID, OrderID)
Query:
1. List all orders put yesterday.
2. How many items were ordered yesterday?
3. List all orders which order more than 3 items yesterday.
4. How many orders which order more than 3 items yesterday?| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
AnswersFor any table, say order table, it was loaded some data double. Write a query to list the double loaded records with all columns and double primary key, but each double records only show once.
- hwei January 07, 2011| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.